View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Stephen[_6_] Stephen[_6_] is offline
external usenet poster
 
Posts: 9
Default Find text and remove row

I have a 10 column list. that list can have anwhere from
40-60 rows depending on the days information.

I want to search column c for any cell containing the
text "money market". once it finds a case where the cell
contains the words "money market", then it highlights
that entire row and delets it. then goes on to the next
case and does the same.

example cells:

NEW YORK MONEY MARKET
LOS ANGELES MONEY MARKET FEBRUARY FUND
BELGIUM MONEY MARKET FUND DECEMBER

etc.

really appreciate any help available.

thank you.