Below is a macro used to delete the entire row if a the cell in the specified column is blank.
Can anyone suggest a way to change this macro so that it can be used to delete a row if the cells in two different columns are both blank?
ie. If any cells are in the same row of column B and E are blank then delete that row.
The code I have used for a single column is this:
Sub DeleteRowOnCell()
On Error Resume Next
Columns("E:E").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
ActiveSheet.UsedRange
End Sub
Thanks in advance!!
Bookmarks