/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 vote238 views1 answer
Vbs run with cscript
VBA
3 votes242 views1 answer
Excel insert blank row for value change in column
VBA
0 vote234 views4 answers
Vgrive,deb
VBA
1 vote218 views1 answer
Excel vba get column name from number
VBA
0 vote204 views1 answer
Vba argument is set
VBA
0 vote224 views1 answer
How to make a if statement with vbs
VBA
0 vote236 views1 answer
Weekday vba
VBA
0 vote223 views1 answer
Excel vba hide columns
VBA
0 vote233 views1 answer
Excel vba saveas no prompt for overwrite
VBA
1 vote231 views2 answers
Excel vba password protect
VBA