![]() |
#7
|
||||
|
||||
![]()
You could change:
.MatchWholeWord = True to: .MatchWholeWord = False but this might have quite undesirable effects. For example, if the found word also forms part of longer, unrelated, words, those might get updated too. You might get better results inserting: .MatchAllWordforms = True after: .Replacement.ClearFormatting but that, too can have undesirable results. Test both on a document, with: .Replacement.Highlight = True inserted after: .Replacement.ClearFormatting and set your preferred highlight colour before running the macro. If you don't get the desired results, you'll need to insert an additional F/R expression for each plural.
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
Find and replace multiple values, according to table value - excel formula | EtanM | Excel Programming | 3 | 04-11-2016 01:43 AM |
![]() |
admyers | Excel | 1 | 09-16-2015 10:28 AM |
Find/Replace is not working - Excel 2010 | fieldhaven | Excel | 2 | 02-19-2014 08:30 AM |
Find - Replace Macro using a table list | mdw | Word | 0 | 08-01-2013 04:36 PM |
![]() |
dmarie123 | Word VBA | 15 | 04-02-2013 07:54 AM |