If you don't want a code solution try DataFilterAutofilter, filter column
A for Apples and delete the filtered rows, either by deleting the entire
rows or clearing the data from the rows and re-sorting (blanks will drop to
bottom)

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
HIS


"supamari0" wrote in message
...
I need to create a macro (probably can only be done through VB) that
deletes
rows based on a specific criteria. It should delete all rows that don't
have
a specific thing typed in it.

For example, the macro would delete all rows that don't have apple in the
cells under the A column (A1, A2, etc..)

Any way at all to do that?