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
|