I have an excel spreadsheet that can have a number of rows with a zero in column 10 (“quantity”) and some rows with text subheaders where the quantity cell is BLANK.
I’m trying to develop a macro to delete the rows where the quantity cell is zero but it also deletes the subheader row. It seems to me that the simple test I’m doing does not discriminate between zero and blank.
If Worksheets(1).Cells(lnRowCount, 10) = 0 Then
rnSelection.Rows(lnRowCount).Delete
Is there a better check method to do this. I guess a couple of nested IFs might work:
If Isblank then skip else if zero then delete.
Is there a more elegant way?
