VBA - MACRO
Pages
Home
What is VBA
Download
Internet
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:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment