/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 vote193 views1 answer
How to extract a file from an ISO:
VBA
0 vote205 views1 answer
Vba is integer
VBA
0 vote195 views1 answer
Excel vba chrw max value
VBA
0 vote202 views2 answers
Open url from vba
VBA
0 vote202 views1 answer
Vba min
VBA
0 vote208 views1 answer
Rotate image by any angle vb.net
VBA
0 vote197 views1 answer
Vbnet display all axis labels in cahrt
VBA
0 vote235 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote205 views1 answer
For each item in folder outlook vba
VBA
1 vote212 views1 answer
Excel how to format bytes as KB, MB, GB
VBA