Updated: March 2009
Returns the length of a match found in a search string.
The following code illustrates the use of the Length property:
Function RegExpTest(patrn, strng) Dim regEx, Match, Matches, s ' Create the regular expression. Set regEx = New RegExp regEx.Pattern = patrn regEx.IgnoreCase = True regEx.Global = True ' Do the search. Set Matches = regEx.Execute(strng) ' Iterate through the Matches collection. s = "" For Each Match in Matches s = s & "Match found at position " s = s & Match.FirstIndex & ". " s = s & "Match Length is " s = s & Match.Length & "." s = s & vbCRLF Next RegExpTest = s End Function MsgBox(RegExpTest("is.", "IS1 is2 IS3 is4"))