View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
supamari0 supamari0 is offline
external usenet poster
 
Posts: 6
Default Macro that deletes certain rows only

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?