Iterate through Array While in For Each loop

Hello All,

I've got a piece of code that works great, but I'm trying to turn it into a function where I can use it with multiple files.

What I'm doing here is parsing a JSON file into a worksheet. The JsonConverter example shows it looking through a defined list of "values":

Please Login or Register  to view this content.

For each file it's looking at, I'd like to see it iterate through the first row of its respective sheet. I've got the values of the header row of that sheet in an array (DirArray):

Please Login or Register  to view this content.

But I don't know how to iterate through that while it's going through the For Each statement that populates the sheet.

I'd like to be able to do something like this:

Please Login or Register  to view this content.

Thanks for any help. Seeing how to do this would be useful.

Full Sub for reference:

Please Login or Register  to view this content.

Maybe something like this (although it doesn't work)?

Please Login or Register  to view this content.

Figured it out:

Please Login or Register  to view this content.