Enhancing FIND/REPLACE script

[terryhenderson]

Hi All,

Following is a script for finding strings in ColA (find) and ColB (replace) of Sheet1, and replacing them in a range of columns in Sheet2 (A:H).
It works fine, but slowly, for small portions of data e.g. 400 rows. But when it comes to a large number of columns and rows e.g. 30,000+ it does become extremely slow and may finish the job in more than two hours!!
Can this code be enhanced, or restructured in order to accomplish the job in a much shorter time?
I do appreciate any expert assistance with this matter.
Always, many thanks in advance.

Please Login or Register  to view this content.

[bakerman2]

Load both ranges into memory and conduct find and replace there. Then write range with changes back to worksheet.
If possible post workbook example.