View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mami mami is offline
external usenet poster
 
Posts: 7
Default MACRO: Multiple Find / Replace

I want a macro that searches a worksheet for specific strings and replaces
these with another.
In detail:
Search on worksheet (whole worksheet, i.e. lots of rows)
Find: "CAR" and replace with "MIS-CAR"
AND
Find: "BAG" and replace with "MIS-BAG"
AND

etc etc

I need about 20 such FIND-REPLACE in this same macro.

Can you help me, since I got no clue of VBA ???
Thanks