View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
JS[_7_] JS[_7_] is offline
external usenet poster
 
Posts: 9
Default How to Find&Replace with MatchWholeWord?

Hi All:
I need to Find and Replace text in excel, however I'm bumping into a
problem: parts of longer words are being found by shorter words and these
parts are being then replace with the ReplaceWith text.
Word's VBA has the "MatchWholeWord Property" that avoids this problem.
Does anyone know if there is a way to do this "MatchWholeWord" in Excel VBA?
Thanks for your help, JS