Delete rows with specific value in a cell

[Ed_B]

How can I delete an entire row when there is a 0 value is a certain cell, say A1.

Thanks for your help

 

[footoo]

I presume you're looking for VBA.
For 0 values in column A for example :

Sub Delete_Rows()
[A:A].Replace What:="0", Replacement:="#Ref!", LookAt:=xlWhole, _
    SearchOrder:=xlByRows, MatchCase:=False, SearchFormat:=False, _
    ReplaceFormat:=False
[A:A].SpecialCells(xlCellTypeConstants, 16).EntireRow.Delete
End Sub

 

[Ed_B]

I had tried several solutions that were in previous threads, but none worked in my situation until yours. Thank you very much.