/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

0 vote326 views1 answer
Vba argument is set
VBA
0 vote331 views1 answer
Vbs
VBA
0 vote342 views1 answer
Openfiledialog specific folder
VBA
3 votes368 views1 answer
Vba post request json
VBA
-1 vote392 views1 answer
Vba sendkeys
VBA
1 vote298 views1 answer
Ms access open form to new record
VBA
0 vote326 views1 answer
Vba dropdown event
VBA
0 vote318 views1 answer
Do until vb.net
VBA
0 vote329 views1 answer
Excel vba show developer tab
VBA
0 vote368 views1 answer
Vba ternary
VBA