Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub DeleteEmptyRows()
- SelectedRange = Selection.Rows.Count
- ActiveCell.Offset(0, 0).Select
- For i = 1 To SelectedRange
- If ActiveCell.Value = "" Then
- Selection.EntireRow.Delete
- Else
- ActiveCell.Offset(1, 0).Select
- End If
- Next i
- End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement