/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 vote146 views1 answer
Vba change named range address
VBA
-1 vote176 views1 answer
How save excel through visual basic
VBA
25 votes290 views3 answers
String to date vb
VBA
0 vote152 views1 answer
Excel vba protect sheet
VBA
0 vote164 views1 answer
Columns dont autoresize on program start vb.net
VBA
0 vote163 views1 answer
Excel last used row
VBA
0 vote143 views1 answer
Vba test optional argument
VBA
0 vote147 views1 answer
Excel vba current folder
VBA
0 vote148 views1 answer
COMO GRAVAR U VALOR NO ARQUIVO APPSETINGS EM VB NET
VBA
0 vote128 views1 answer
How to self delete a vbscript file
VBA