/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 vote222 views1 answer
Vba remove last vbcrlf
VBA
0 vote242 views1 answer
Search for text in every worksheet excel visual basic
VBA
0 vote206 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote224 views1 answer
Vba compare strings
VBA
0 vote243 views1 answer
Vba verticalalignment
VBA
0 vote283 views1 answer
Vba is integer
VBA
0 vote174 views10 answers
Vba excel create event log
VBA
0 vote227 views1 answer
Vba array dimensions
VBA
0 vote215 views1 answer
Excel vba range contains
VBA
0 vote224 views1 answer
Vba string start with
VBA