Return Regular Expression match to array

Good afternoon

I am trying to extract key information from a large data set. The data is in string format and a regular expression will pull the required data quickly.

The sub routine works excellent when I simply print it to the immediate window.
However, I would like to return the match to an array and then eventually to a range on a worksheet.

Please Login or Register  to view this content.

Hi 6StringJazzer,

Thank you for responding. It does run but throws the following error message at the line you quoted.

Run-time error '9':
Subscript out of range

I've checked that the destArray is properly sized. I don't understand how the MatchCollection works so I think that's where I am making a mistake. If I comment the line out, the script prints all of the RegEx matches on to the immediate window, as expected. I would like the script to take the RegEx match and put it in the appropriate location of the destArray

Thanks again for helping me clarify the issue.

Change

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

Thank you! That was the issue!

appreciate the time you took to review the code. Having a working regular expression script will save me huge amounts of time in the future.

I've marked the thread as solved.