VBA to loop through cell-defined range and paste table output after each loop.

Someone may post prettier code, but an option:

Please Login or Register  to view this content.

It could be consolidated so that the case statement is inside all the loops and only applies to the "If myArr(j, k)..." line, which is more compact, but would execute the select a lot more times and in theory is less efficient.

Thanks for the rep mscott123 If that means the issue is resolved, please mark the thread as solved?

Thanks Arkadi, so impressive!

To be honest, I wasn't anticipating this approach.

I think its solved by my VBA come up short and I'll need to try to figure out a couple of small changes, any further advice is most appreciated:
I noticed blank table 1 cells were being picked up with 'a's in the output (*** case), how would I modify them just leave them blank?

In reality, my actual table size is much larger and my secondary objective was to insert some additional actions with my model output after each new table 'punch-card' was generated.
For example after the first 3x4 table is generating, I would copy and paste model outputs from and to elsewhere.

Really appreciate everything

I guess the blank cells are only an issue in the Incremental version?

Change:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

(in the For "k" loop)