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