(Solved) – VBA Regex: from last used row, in a column,get count of a matched pattern between another pattern


I’m new to VBA using regex. On a worksheet, I have a column with cells that have several specific names and between these names are several qualifiers. I need help to put together a VBA/macro code using regex to loop through the column and get the counts of the qualifiers between names and put the count value to the cell on the right of the name. The names all start with uppercase letters while the qualifiers start with a lower case letter. So i’m using ^[A-Z]* to match the names and ^[a-z]* for the qualifiers. Each value is in separate cells and the occurrences are random. So far I can only get total count of all qualifiers. I appreciate the help.

enter image description here

Leave a Reply

Your email address will not be published. Required fields are marked *