hi,
i have the following code:

For Each c In Range("H1:H1000")
If c = 0 Then c.EntireRow.Delete
Next

i need to delete rows in which the value is 0 for column H..
the above code does not work for some reason....

also,i need to capture the range correctly..coz the actual number o
rows is different at different types..how do i capture the range an
delete the rows having column value 0......??

--
Message posted from http://www.ExcelForum.com