/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 vote228 views1 answer
Excel vba StartUpPosition
VBA
0 vote232 views1 answer
Find days in month vba
VBA
0 vote242 views1 answer
Prive sub enter clicked vb
VBA
0 vote264 views1 answer
Vbnet check if string is only numbers
VBA
0 vote246 views1 answer
Vba search string position
VBA
1 vote229 views2 answers
Vba find last row in range for certain criteria
VBA
-1 vote269 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote287 views1 answer
Vba excel do not recalculate before save
VBA
0 vote225 views1 answer
Excel vba current folder
VBA
0 vote274 views1 answer
Excel vba protect sheet
VBA