/VBA/Dlete rows with blanks and space " " vba

Dlete rows with blanks and space " " vba

Dim iCounter As Long
With Application
    .Calculation = xlCalculationManual
    .ScreenUpdating = False
    For iCounter = Selection.Rows.Count To 1 Step -1
        If WorksheetFunction.CountA(Selection.Rows(iCounter)) = 0 Then
            Selection.Rows(iCounter).EntireRow.Delete
        End If
    Next iCounter
    .Calculation = xlCalculationAutomatic
    .ScreenUpdating = True
End With

Source: powerspreadsheets.com

Similar codes

-1 vote250 views1 answer
How save excel through visual basic
VBA
2 votes225 views2 answers
Constructor vb.net
VBA
25 votes293 views2 answers
Excel vba folder exist
VBA
0 vote200 views1 answer
Vba select file in folder
VBA
5 votes225 views1 answer
Excel vba how to unit test vba code
VBA
1 vote228 views1 answer
Textbox find and replace vb
VBA
6 votes240 views1 answer
Excel vba check if a string only contains letters
VBA
0 vote234 views1 answer
Excel vba disable keyboard input
VBA
0 vote239 views2 answers
Get excel file from email attachment in vba
VBA
2 votes191 views1 answer
Excel vba pause
VBA