/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 vote256 views1 answer
Vba clear collection
VBA
5 votes215 views1 answer
Vba array worksheet.index
VBA
0 vote229 views1 answer
Add items to combobox vb.net
VBA
0 vote229 views1 answer
Excel vba clear filter
VBA
0 vote242 views1 answer
Compare dates vb
VBA
0 vote274 views1 answer
Vb ternary
VBA
1 vote226 views1 answer
Vba ubound array 2-dimensional
VBA
1 vote244 views1 answer
Export datagridview to excel vb.net
VBA
0 vote233 views1 answer
Vba add spaces
VBA
0 vote248 views1 answer
VB Error Code BC30201
VBA