Excel vba delete empty rows

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

Excel vba delete empty rows

' Deletes empty rows
dim rRange As Range, rowsCount As Long, i As Long
Set rRange = ActiveSheet.Range("A1:B100")
rowsCount = rRange.rows.Count
For i = rowsCount To 1 Step -1
    If WorksheetFunction.CountA(rRanges.rows(i)) = 0 Then 
        rRange.rows(i).Delete
    End If
Next

-1

Source: stackoverflow.com

Similar codes

0 vote186 views1 answer
For each item in folder outlook vba
VBA
0 vote182 views1 answer
How to get the value of optionbutton in vba
VBA
0 vote172 views1 answer
Vba shape transparent
VBA
0 vote173 views1 answer
Internet explorer reference vba
VBA
0 vote170 views1 answer
Check range is in another range vba
VBA
0 vote213 views1 answer
Amd64 vs arm64 linux
VBA
-1 vote184 views1 answer
System.Data.OleDb.OleDbException: 'No value given for one or more required parameters.'
VBA
0 vote168 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote180 views1 answer
Pivot data source not accepting table named range vba
VBA
2 votes172 views2 answers
Excel vba copy values range to another range
VBA