Saturday, December 25, 2010

Macro : REMOVE BLANK SPACE FROM SHEET

Sub DeleteBlankARows()
Dim r As Long
For r = Cells(Rows.Count, 1).End(xlUp).Row To 1 Step -1
    If Cells(r, 1) = "" Then Rows(r).Delete
Next r
End Sub

No comments: