What are the rules for a valid hit? How many digit/characters need to be included for it to be a hit?
For instance which of the following are hits
a123 a1 A1 1a 1A TF2 A12 AB12 ABC1 abc123



A 'not completely unrelated' question with code was looked at on this thread End With without With - except there is a With - Solved - Eileen's Lounge after being asked on this forum. If you study the code shown in that thread you can have a go at adapting that as your first steps. There is likely to be a faster running solution based on the answer you provide for the above questions but that code could give you enough clues to get you started.

__________________
Andrew Lockton
Chrysalis Design, Melbourne Australia

Technically all the examples are hits because the documents I'm reviewing have references to equipment but every piece of equipment has a different abbreviation based on type (e.g. Valve=V, Motor=MTR....) and different numbers based on location and how many there are in the field (e.g. Area 82, Valve#123 = 82V123 OR Motor#12=MTR12). I know it's kind of vague but some could be 4 characters (with 2 letters and 2 numbers) and others can be 10 characters (with any combination of numbers and letters). Again I know it's not a simple request so I will take anything I can get.

Honestly even if I got the macro to highlight everything, I would still go through the document to confirm that what it identified should be highlighted. That is why the extra part in my request would help me a little more, because if I had a separate list I could review what was highlighted and not have to scroll through the pages. Then I could verify based on that list and if that list is in a different location and I have confirmed everything, I can just delete the list and save the original file with the highlighted equipment numbers.

Please let me know if you have any more questions or if I need to clarify something.

Also I haven't looked at the other forum you mentioned yet but I will definitely check it out and see if I can tweak it to fit my needs. Thank you!