HI

Write code to iterrate through column C or per examle set C5 as activecell
then the following code will do the job


If ActiveCell.Value = "0" Then Selection.EntireRow.Delete

There are other varients of this code

Best N10


"Dave" wrote in message
...
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?


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.771 / Virus Database: 518 - Release Date: 28/09/2004