Script/Macro to delete certain rows

D

DanFox

Can anyone suggest a script i can use to search a worksheet, identify
an entry and delete the row?

i.e.

I want to delete rows containing 'NOP'

1 WAP
2 NOP
3 WAP
4 DEB
5 NOP

The script/macro would automatically delete rows 2 and 5.

any ideas?
 
Top