Hello every one,
need a code that G column OR H column value is zero then delete entirerow. if any value is available in G or H Column then dnt delete row.
Exp:
i have code that work is fine if only 1 column value is zero.
Thanks in Advance.
need a code that G column OR H column value is zero then delete entirerow. if any value is available in G or H Column then dnt delete row.
Exp:
0 | 1 | Dnt Delete |
0 | 0 | delete |
1 | 1 | Dnt Delete |
VBA Code:
Sheet7.Range("A3:H3").AutoFilter field:=6, Criteria1:="="
Sheet7.Range("A5:H150").Offset(1, 0).SpecialCells(xlCellTypeVisible).EntireRow.Delete
Sheet7.AutoFilterMode = False