/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 vote350 views1 answer
Le contrôle SpinButton (Toupie)
VBA
0 vote349 views1 answer
Vba sheet visible
VBA
4 votes366 views1 answer
Excel vba how to programmatically remove the marching ants after range copy
VBA
0 vote345 views1 answer
Discern between file and folder given path vb.net
VBA
1 vote344 views1 answer
Excel vba close form escape key
VBA
0 vote348 views1 answer
Vbnet add new ecel sheet
VBA
0 vote350 views1 answer
Label de tableau dans des label.text en VBA
VBA
0 vote418 views1 answer
Excel web scraping
VBA
0 vote356 views1 answer
Excel run macro every 5 minutes
VBA
0 vote323 views1 answer
Add items to combobox vb.net
VBA