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.