Need VBA macro "find replace" from list on sheet 1 cycling through the entire workbook

Good afternoon,

I'm looking for a VBA script that can do a find replace over all the worksheets in my Excel 2010 workbook.
The strings to find are listed on Sheet1 in column A under the header 'find'.
The replacing text is stored on Sheet1 in column B under the header 'replace'.
Until somebody takes the time to code the external dbase from which I'm pulling my data properly I will need to use this macro on all my excel reports.
Hence I will appreciate your help gratefully.

A big thank you in advance!

You can try this one.

Please Login or Register  to view this content.