Wildcard search for string within a string?
 

I am trying to write a macro that will allow me to put the contents of the
ActiveCell into a string and search that string for all occasions of a
substring using wildcards. The substrings will all start with a capital
letter A, B, C, or D and will all have either one or two numbers. There may
be more than one substring in a string, so I need to loop through the string
to find all occasions.

I'm not sure how to put the wildcard search together? Mid? InStr?
Something else? Any help is appreciated.

Ed