For Loop Array

[sperryxx]

First of all YAY the forum is finally back to normal! Thank you

So this is probably exceptionally simple but maybe I've just been doing too much coding where everything looks the same.

Background:
I'm trying to write a simple macro to create an input to Unix for something a program I'm calling and giving all of it's inputs, over and over again. I'm automating this so I'm not entering in the 100k+ runs manually. I'm stuck on getting vba to output the array to the sheet properly.

Please Login or Register  to view this content.

So if you enter in 2 for the files and 3 for the runs it should output something that loops like:

example_output.xlsx

Any help would be appreciated. Thanks

[patel45]

can you explain the logic ?

[TMS]

Maybe this:

Please Login or Register  to view this content.

Regards, TMS

[MickG]

Another Option:-

Please Login or Register  to view this content.

[TMS]

In light of MickG's response, a slightly shorter/neater version:

Please Login or Register  to view this content.

Regards, TMS