![]() |
|
#1
|
|||
|
|||
![]() Hi macropod, Incredible thank you for this macro!!! I only discovered macros today and your initial macro works incredibly well for my purpose (highlighting the specific mentions of companies that I need to check for and report). 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)? 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. Thank you for sparking my interested in VBA and macros! Abigail |
#2
|
||||
|
||||
![]() Quote:
Code:
StrFnd = "dog|cat|pig|horse|man|" & _ "dogs|cats|pigs|horses|men" Code:
StrFnd = "dog|cat|pig|horse|man|" StrFnd = StrFnd & "dogs|cats|pigs|horses|men" Quote:
__________________
Cheers, Paul Edstein [Fmr MS MVP - Word] |
#3
|
|||
|
|||
![]()
Fantastic! Thank you for such a prompt response and all your help!
|
#4
|
|||
|
|||
![]()
Hey Macropod,
Thank you for this amazing code, it has saved me hours of work. I know it has been a while since your last response, but the code doesn't seem to identify words that are in headers, footers, and text boxes. I found that word documents are broken down into 17 stories. Mastering VBA for Microsoft Office 2013 - Richard Mansfield - Google Books What changes can be made in order for the macro to catch words in some or all of the stories? Thanks, Ariana |
![]() |
Tags |
find, highlight, multiple keywords |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
APAV | Word | 9 | 10-09-2017 01:17 PM |
Highlight text and find next instance | DrDOS | Word | 0 | 11-15-2010 04:02 PM |
Lock words in a document, but allow for input within the document | tlinde | Word | 1 | 02-09-2010 09:07 PM |
FInd recurring words in Word 2003 | NJ007 | Word | 4 | 01-25-2010 03:11 PM |
find - reading highlight - highlight all / highlight doesn't stick when saved | bobk544 | Word | 3 | 04-15-2009 03:31 PM |