/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 vote168 views1 answer
Vba pass named range to function
VBA
0 vote176 views1 answer
Reset border color textbox vba
VBA
0 vote169 views1 answer
WGET FTP
VBA
1 vote161 views1 answer
Excel vba Populating a combobox on a userform from a range of cells
VBA
0 vote170 views1 answer
Excel vba linter
VBA
3 votes177 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA
0 vote184 views1 answer
Excel filter by date not working vba
VBA
0 vote167 views1 answer
Menus act like radio buttons vb.net
VBA
0 vote181 views1 answer
Excel vba paste all to each sheet in workbook
VBA
0 vote175 views1 answer
Vba format currency
VBA