View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Andrei Andrei is offline
external usenet poster
 
Posts: 53
Default Need macro that delete rows starting with specified letter/word

Let' say i have a column with with lot of cells containing various words .
I need a macro that eliminates the rows which contain that letter/word at
the begining of the cell . Example , from A1 to A9 i have in the cells the
following : mom , dad , son , mom , dad , son , mom , dad , son . I want to
eliminate every cell that contain "mom"