I am trying to write some code to delete an entire row if the cells in columns A, B and C are empty. When I try the code, I get the error message "Delete method of range class failed." Any suggestions would be appreciated.
Dim bottomE As Long
bottomE = Range("e" & Rows.count).End(xlUp).Row
Dim i As Long
For i = bottomE To 4 Step -1
If .Range("A" & i) = "" And .Range("B" & i) = "" And .Range("C" & i) = "" Then .EntireRow.Delete