VBA
Sunday, April 21, 2019
To remove row base on 1st cell ranges that is blank
To remove row base on 1st cell ranges that is blank
Sub RemoveEmptyRows()
On Error Resume Next
Range("G1:G100").Select
Selection.SpecialCells(xlCellTypeBlanks).EntireRow.Delete
End Sub
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment