Find / Replace with Multiple Values

Hi guys,

I need to be able to find/replace multiple values in a spreadsheet. So:

- one sheet contains the values i need to search for and their replacement ("Sheet2")
- the other contains the data that needs to be changed

Here is the macro that i have :

Please Login or Register  to view this content.

The problem I'm having is that the macro is not replacing correctly all the data. For the first 3 digit data (until Row 687) it works fine but when the 4 digit data comes, errors start to appear (I colored the cells to be more obvious ).

If I run the macro, only for the 4 digit data (by deleting the find/replace data for the 3 digit) then it works fine.

I also tried making 2 separate macros for the 3 and 4 digit data and calling them from a main macro, but I still get errors.

Thanks for any suggestions.

Hello ciprian,

Welcome to the Forum!

I rewrote your macro using a different method that is faster. This method also corrects the problem you were having. This macro dynamically adjusts for the find and replace values as well as the raw data.

Please Login or Register  to view this content.

Thank you for the code, it is great and way faster then what i had before. I made some changes so that it will change the value in the actual cell and also extended the find and replace to include the second column

Please Login or Register  to view this content.

Hello ciprian,

Good job on changing the code! You don't need the Offset(0, 0). You can do this way also...

Please Login or Register  to view this content.