I'm looking for some code that will determine whether a cell in a targeted range has any strings that conform to the pattern of a 1 to 3 digit number followed by a letter from A to M. I need something that will hide any row in which cells(cel.row,20) contains a match for such a pattern.
"SEAT AUDIO JACK LOOSE, WORLD TRAVELLER SEAT 37H. SEATS AFFECTED / IN FLIGHT" would be a positive match and so cel.EntireRow.Hidden = True
"AUDIO ENTIRE CABIN INOP" would not.
I haven't tried using RegEx for 2-3 years so I'm pretty much starting over. Please post the entirety of a sub that would look for pattern matches in Range([T6], [T10000].end(xlUp)).
I think the pattern statement would be something like this but I'm not at all sure:
.Pattern = "(\d+[A-M])"
.Global = True
.IgnoreCase = False