Find and replace only whole words (loop)

[dannel]

Hi All

I am trying to find any word from selected range in my sheet 1 and replace it with another word from a list saved in Master Sheet (Column A - match and Column B- Replace). I found the below code on the net and it works fine, however it replaces even if the word is a part match, which I would like to avoid

For eg :
1. "Narrow" - Correctly Replaces with "Wide"
2. "Narrow Road" - Incorrectly Replaces with "Wide Road" (even if this is not a part of my replacement "Master" Sheet.)

Please Login or Register  to view this content.

Thanks,

[protonLeah]

Your sample file is inadequate. You need samples of occurrences to replace as well as those which will not be replaced.

[dannel]

Thanks for your suggestion. attached a new file with more examples.

[AB33]

The default match is xlpart, so you need to change it into a whole

Please Login or Register  to view this content.

[dannel]

thank you so much. It works !!!