Dear all!
I am trying to delete all rows in my sheet where Column H and F are blank.
I know how to do it with one criteria but when I add the second one it stops working. Any suggestions?![]()
Sub deleteBlank() Dim Lastrow As Integer Lastrow = Range("A" & Rows.Count).End(xlUp).Row Range("H2:H" & Lastrow, "F2:F" & Lastrow).SpecialCells(xlCellTypeBlanks).EntireRow.Delete End Sub
Regards
Bookmarks