Hello Again Forum,
I am trying to delete rows when ever a cell in column G says "No Data" and a cell on the same row in column E is blank.
Below is my code:
lRow = Cells(Rows.Count, "A").End(xlUp).Row
Do While lRow > 0
If Cells(lRow, 7) = "No Data" And Cells(lRow, 5) = "" Then...