/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 vote232 views1 answer
How to INPUT text in shape with enter and spacein vba
VBA
0 vote305 views1 answer
Find control with name vb
VBA
0 vote271 views1 answer
VBA Sort RossetaCode
VBA
0 vote235 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote271 views1 answer
If statement vdhl
VBA
0 vote226 views1 answer
Vba add spaces
VBA
0 vote291 views1 answer
Vba is integer
VBA
1 vote227 views1 answer
What does vbs stand for
VBA
1 vote225 views1 answer
Vba delete file
VBA
1 vote239 views1 answer
Excel vba array remove first
VBA