Easiest would be to sort and delete or datafilterautofilterdelete or a
looping macro

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"RMT" wrote in message
...
How do I delete several rows that don't have the word total. I want to
keep
the rows with word total in column A.
Thanks