Here is one way
Sub RowZapper()
If Sheet1.Range("c5") = 0 Then
Sheet1.Range("c5").EntireRow.Delete
End If
End Sub
Christy;)
"Dave" wrote:
I'm looking for a macro/VB code that will evaluate a cell
and if it meets the criteria, will delete the row.
For example, if cell c5=0, then delete that row.
Can anyone help?