Hi, I was trying to write a macro for a spreadsheet I have. What I would like to do is, between a range of cells, if the cell value is 0 then delete the entire row. Now I have been working on code for this, but I have failed every time with the macro deleting all rows. Here are some snipits from my code.
For Each C In Worksheets("Sheet2").Range("B4:B3556")
If C.Value = 0 Then
Any help with this would be Great.