macro find&replace only exact value

Hi Everyone,

This macro finds and replaces multiple values found on another sheet. however, it does not only take the exact value, also others.
Example:

If i want to change "Example 1", "Example 2", ... "Example 10" into "One", "two", etc

Example 10 then changes into "One 0" because it changes the Example 1 (without the 0 in 10) into One.

Is there any way to alter this (or do you have another macro to replace multiple values?

Thanks in advance!

Please Login or Register  to view this content.

Maybe you could add the: "LookAt:= xlWhole" parameter in the find/replace function or, you might be able to verify that the lengths of the two string are equal.