/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 vote134 views2 answers
Excel vba number format file size
VBA
0 vote113 views1 answer
Add Formula to Shape Text in VBA
VBA
0 vote140 views2 answers
S yyyy-MM-dd em vb net
VBA
0 vote126 views1 answer
Vba add spaces
VBA
0 vote74 views1 answer
Vba code to remove leading and trailing spaces
VBA
2 votes110 views1 answer
Excel vba extract file name
VBA
0 vote138 views1 answer
Vba range clear formatting
VBA
4 votes128 views2 answers
Vba create folder if not exist
VBA
1 vote115 views1 answer
VBA Loop through recordset
VBA
1 vote123 views1 answer
Add a index column power bi
VBA