Macro to use cell references and text to replace words in workbook

[poitbot]

Hello,

I have data listed in a worksheet that contains text in the first column that needs to be replaced throughout the entire workbook.

The data looks similar to this:

Sun, $D$8#Home, $B$42#WWB, $B$3#Definitions
Earth, $D$18#Summary, $B$3#Page 1, $B$42#Classroom
Ball, $E$27#Home, $B$4#WWB

The first column being a piece of text to be replaced in the workbook on multiple worksheets. The second, third, fourth, etc... columns are the cell addresses and worksheets separated by the "#" (Pound) sign.

So if "Sun" was to be changed to "star" the script would change the word sun in the worksheet Home and cell reference D8 to star.

Thanks,

Poit

 

[Joe4]

Duplicate:
http://www.mrexcel.com/forum/showthread.php?t=494446

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted:
http://www.mrexcel.com/forum/showthread.php?t=127080