I am new to vba regex and I need to find the fields in a very large report where the text in a text field or text cell contains 3 or more occurrences of the following pattern:
"submit report" or "submitted report" or "submitting rep" or "resubmitted rep" or "resubmitting report" using vba regex, case insensitive.
I have not been able to figure out the regex and the condition count so it could be adjusted to 2, 3 or more.
Any guidance will be greatly appreciated.
Aucun commentaire:
Enregistrer un commentaire