Find and Replace Whole Words (like in Word)

J

John Svendsen

Hi All:
I need to find and replace text using VBA and the only feature available in
VBA is the Replace Function. The problem is that I this functions has no
'matchcase' and/or 'matchwholeword' (like Word's Find Property).
Can someone point me towards any possible piece of VBA code that may add
'matchcase' and 'matchwholeword' functionality to VBA find and replace
function?
TIA,

JS
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Change a great number of words in word files, with a macro as short as possible. 5
Word macro that can call cells out of Excel for a find and replace 0
Word Macro for multiple searches, incl. in footnotes 2
Find/Replace macro only limited to selection when entire paragraphis selected 22
Find & Replace all words, except words in green 4
Sequentically find and replace 4
newbie needs help with 'REPLACE' 1
Find and Replace in VBA 3

Top