View Single Post
 
Old 10-04-2022, 05:19 PM
Guessed's Avatar
Guessed Guessed is offline Windows 10 Office 2016
Expert
 
Join Date: Mar 2010
Location: Canberra/Melbourne Australia
Posts: 4,176
Guessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant futureGuessed has a brilliant future
Default

Post a sample workbook which demonstrates the type of content that the code needs to work on. Also explain the difference between 0 and 0.00 - is the formatting of the number as a string relevant to whether the row gets deleted?

If you want a copy of a worksheet that deletes any rows which include zero values in four columns then this logically would be cleaner to do by replicating the worksheet and removing the rows you don't want. This will allow you to preserve row and column heights and be simpler to code IMO.
__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia
Reply With Quote