View Single Post
 
Old 10-09-2017, 09:03 AM
Abiwoop Abiwoop is offline Windows 7 64bit Office 2010 64bit
Novice
 
Join Date: Oct 2017
Posts: 2
Abiwoop is on a distinguished road
Default Exceeding the allowed number of characters in one line

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
Reply With Quote