hello everyone

[andymalan]

i have a number of rows in a worksheet and most of the cells in each row has a formula that returns the value 0.
i need to delete the entire row if the cell in column A of the row is 0.
my search has brought me to the code below, that also does not work.

    Dim LastRow As Long
    Dim i As Long
last = Cells(Rows.Count, "A").End(xlUp).Row

'Delete rows
    For i = last To 2 Step -1
        If (Cells(i, "A").Value) = 0 Then
                Cells(i, "A").EntireRow.Delete
        End If
    Next i
[code]
any help will be greatly appreciated

 

[Peter_SSs]

Duplicate to delete rows that have formulas that equal 0

Please do not post the same question multiple times. Questions of a duplicate nature will be locked or deleted, per #12 of the Forum Rules and points 6 & 7 of the Forum Use Guidelines.

Any bumps, clarifications, or follow-ups should be posted to the linked thread.