Microsoft Office Forums - View Single Post - [Solved] Find and highlight multiple words in MS Word document

macropod · 10-09-2017, 01:13 PM

Quote:

Originally Posted by Abiwoop

Only since I have roughly 250 company names to check for in a single word doc, I exceed the StrFnd line symbol limit and the macro skips the preceding lines (connecting with " _ " didn't work of course).

Is there a way to fix that (without having 3 separate macros)?

You could use:

Code:

StrFnd = "dog|cat|pig|horse|man|" & _
  "dogs|cats|pigs|horses|men"

or:

Code:

StrFnd = "dog|cat|pig|horse|man|"
StrFnd = StrFnd & "dogs|cats|pigs|horses|men"

Quote:

Originally Posted by Abiwoop

I looked into your suggestion to have data pulled from excel sheet (https://www.msofficeforums.com/word-...d-replace.html), but since it's my very first macro, can't see how to work it into your original HiLightList macro.

The macro there would work just as well, with just the few minor mods needed to implement highlighting instead of text replacement.