The Simple code below deletes all blank rows in data contained in the range (A1:A10000)
What I would like to do is delete any rows that have no Data in the row at all in any cell. If there is not an easy solution to this, no data in each row A1:Z10000.
So if A1 to Z1 have no date, delete this line, move to next & apply same.
Ideas appreciate.
Sub Simple_Blank_Row_Delete()
Range("A1:A10000").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
What I would like to do is delete any rows that have no Data in the row at all in any cell. If there is not an easy solution to this, no data in each row A1:Z10000.
So if A1 to Z1 have no date, delete this line, move to next & apply same.
Ideas appreciate.
Sub Simple_Blank_Row_Delete()
Range("A1:A10000").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub