/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 vote185 views1 answer
How to add line graph vb net
VBA
0 vote219 views1 answer
Vba excel parser xml
VBA
0 vote173 views1 answer
Excel vba clear filter
VBA
0 vote179 views1 answer
Excel vba protect sheet
VBA
0 vote158 views1 answer
Le contrôle SpinButton (Toupie)
VBA
27 votes321 views2 answers
Vba check if file exists
VBA
0 vote166 views1 answer
Excel VBA web scraping
VBA
1 vote193 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
0 vote223 views1 answer
Find control with name vb
VBA
0 vote159 views1 answer
Vba argument is set
VBA