/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

1 vote150 views2 answers
Vba function return array
VBA
0 vote152 views1 answer
Test if form is open vb
VBA
0 vote189 views1 answer
Check if cell is dbnullvb.net
VBA
1 vote159 views1 answer
How to check is the value enterd is a number or text in vba
VBA
0 vote152 views1 answer
Vba timestamp -- milliseconds
VBA
1 vote105 views1 answer
Vba Remove Case Sensitivity
VBA
0 vote158 views1 answer
Combobox dropdown search visual basic -excel -C#
VBA
0 vote244 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote147 views1 answer
Vba add shape oval
VBA
1 vote151 views1 answer
Add a index column power bi
VBA