Turn functions off
 

Hi,

I have a worksheet with a lot of functions. I want to recalculate the
worksheet and then save the result into an array - in a macro. Then repeat
this 1000 times. This calculation does not use any of the functions.

Question = how do you turn off the functions (because this is massively
slowing down my calcs)?

Thanks for your help.

Turn functions off
 

Perhaps you could set the calculation to manual and have the macro calculate
the worksheets or ranges that need to be calculated

For Example:
Application.Calculation = xlCalculationManual
Worksheets("Sheet1").Calculate
Worksheets("Sheet2").Range("A1:C10").Calculate
Application.Calculation = xlCalculationAutomatic


"Jeff" wrote:

Hi,

I have a worksheet with a lot of functions. I want to recalculate the
worksheet and then save the result into an array - in a macro. Then repeat
this 1000 times. This calculation does not use any of the functions.

Question = how do you turn off the functions (because this is massively
slowing down my calcs)?

Thanks for your help.