Try recording a macro
datafilterautofilterfilter on deletedeleteautofiter
or
look in the vba help index for FINDNEXT.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
ups.com...
I would like to use a macro to delete any row that has the word
"delete" in one of its cells. What would this code be? Thanks!