how to delete a row with a cell containing certain number or text

[ann]

How could I delete a row if a cell in the row is "5" or is "order"? Thanks!

 

[Ron de Bruin]

Hi Ann

See this page for VBA code
http://www.rondebruin.nl/delete.htm

 

[ann]

Thanks! It really helps!