VBA
Saturday, April 20, 2019
To delete blank rows
To delete blank rows
Sub rowsdeleteblank()
On Error Resume Next
Sheets("sheet").Activate
Range("b13:b45").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