/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 vote193 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote180 views1 answer
Vbnet check if sting contians symbols
VBA
0 vote194 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
0 vote198 views1 answer
VB get external IP address
VBA
0 vote185 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote184 views1 answer
Excel protect cells with formulas
VBA
0 vote184 views1 answer
VBA Sort RossetaCode
VBA
0 vote134 views1 answer
Vba set vs dim
VBA
0 vote197 views1 answer
Excel vba set cell value to empty
VBA
3 votes195 views1 answer
Extract word in a text in excel
VBA