physical limitations
get more memory and/or faster cpu

--
Hope this helps.
If it does, please click the Yes button.
Thanks in advance for your feedback.
Gary Brown



"Ayo" wrote:

I have this line of code in my macro: Wks.Range("G3:GA732").Calculate

This line of code takes over an hour to execute. The range is all
SUMPRODUCT formulae and I have to run the report daily. It takes about 2
hours to run the report. 90% of that is spent executing the "Calculate" code
above.

What I need to know is this, is there a way to speed-up the Calculating
operation or am I stuck with this?
Thanks