Excel VBA: Out of Memory Error When Copying Large Arrays Worksheet

We had a similar issue when running a master macro that called many sub-macros and the program failed to release allocated memory as each macro completed. This would eventually lock the machine due to the memory being blocked. An update to the program itself solved the real issue.

What we did as a work around was to increment a counter so the macro would quit and re-start to release the trapped memory.

Processing your data in chunks of 50,000 would mean 10 runs which you could call sequentially avoiding crashes and loose less time.