VBA Exceeding Calculation Resources

Thanks for the help on the filling to columns... I know it may not be best practice, but I was autofilling some multi-tiered array formula to be used for some graphing down the line...

However, now that I can successfully populate a nice 40-50 array formula instantaneously within the VBA, I've obtained a new error code that I have never seen before!

"Excel Ran out of resources while attempting to calculate one or more formulas. As a result, these formulas cannot be evaluated"

Is there a VBA command I can use to purge the memory after particular pieces of a long macro have executed?
Or perhaps someone have a website that they can refer me to that explains how to better use Subs and modules to assist in excel memory allocation?


The file itself is only 55kb, but it is currently taking up 835,200k in my task manager. Any ideas?

I'd like to think my code isn't THAT poorly written