Hi
I have used the code
Sub DeleteBlankRows()
Application.ScreenUpdating = False
Range("A2:D19962").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Application.ScreenUpdating = True
End Sub
But it deletes all rows even those with data. What is wrong?
thanks
I have used the code
Sub DeleteBlankRows()
Application.ScreenUpdating = False
Range("A2:D19962").SpecialCells(xlCellTypeBlanks).EntireRow.Delete
Application.ScreenUpdating = True
End Sub
But it deletes all rows even those with data. What is wrong?
thanks