regex works but how do i return the found string to a variable

[jove1776]

Ok I managed to get it to work using the following I found on the net:

Code:

Dim re, testresults, showresults

Set re = new regexp
re.Pattern = "([A-Z]{2})-([0-9]{3})-([A-Z]{1})-([0-9]{2})"
re.Global = true
re.IgnoreCase = true

set testresults = re.Execute(response)
For each match in testresults
    showresults = showresults + match.value
Next

msgbox showresults

Unfortunately I didn't realize in the string i was searching there are 28 separate matches for that search which are all valid but all different.

I just need the very last instance of the match for my purposes.

Does anyone know what the regex is for this?

I am a bit new to regex