Hi

Please don't murder me, if this is worded poorly. So I have this project that you push a button and write named ranges create sheets and write formulas to said sheets. There are about 8 formulas that push to 23 columns that have arrays formed from MMULT, SUMIFS, and just regular Boolean logic.

Outside of this the code runs really fast relatively and the workbook calculates "normally". The problem, I think, is that the array formulas have an inherent dependency so for instance, I have 4 or 5 formulas that feed the array IC1 and similarily for OC1 and then same thing for IC2 and OC2.

IC1 affects values for OC1 and IC2

OC1 affects OC2

IC2 affects OC2

I cannot figure out the proper configuration to allow the arrays to not destroy the calcs. I've tried to eliminate as much volatility as possible and the workbook itself is less than 1 MB after running the code and less than .5MB beforehand. Any thoughts?