Found example was able to modify to get to work. I am quite sure it
can be improved but
this works to find first group.
Function TestRegExp(myPattern As String, myString As String)
'Create objects.
Dim objRegExp As RegExp
Dim colMatches As MatchCollection
Dim RetStr As String
I am looking for syntax on how to capture a group in Excel
I am using Excel 2002 and referencing MS VBScript Regular Expressions
5.5.
my search string is this 10.10.10.132
my regExp.Pattern = 10\.10\.10\.(.*)
How would I get just the 132 returned?
When I hit F1 for help I do not find anything