A macro to replace Text.

[richhhh]

I would likea macro to replace several words in a entire workbook and because the work book will change daily and there may be over 100 different words I would like to consistently change daily which will be the same ones a macro trumps manually using find and replace.

Sample of the words

replace "NYM" with "New York"
replace "TB" WITH "Tampa bay"

There will be alot of them. I would love to see a code doing this that I can add words to.

Thank you for any help

[Olly]

I would set up a "Config" worksheet, with a table to store your old / new string values.

Then you could use something like:

Please Login or Register  to view this content.

See attachment for worked example.

[richhhh]

This forum amazes me. Thank you sir!