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 vote246 views4 answers
How to continue formula in below line in vba code
VBA
5 votes266 views1 answer
Excel vba first byte from INTEGER
VBA
0 vote234 views1 answer
Vbnet line graph smooth lines
VBA
0 vote247 views1 answer
Excel vba protect shapes
VBA
1 vote226 views2 answers
Vba remove first 2 characters from string
VBA
0 vote273 views1 answer
Excel vba convert cells address
VBA
0 vote215 views1 answer
Vba apostrophe chr
VBA
0 vote239 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
3 votes242 views2 answers
Vba active workbook path
VBA
0 vote230 views1 answer
Excel vba Column Name to Column Number
VBA