Hello i read that if set
Application.Calculation = xlCalculationManual
it may speed up your code. I also read you have to turn it back on in later versions of excel but that isn't what concerns me.
Quick question
if it is set tob Manual, what changes?
Does this just mean that if i have a sum formula in a cell somewhere it won't update if i change a cell its depended on?
or
will it affect calculations in my code, like if I specify,
VariableA = 6*ws.cells(1,1)
Thanks!
Application.Calculation = xlCalculationManual
it may speed up your code. I also read you have to turn it back on in later versions of excel but that isn't what concerns me.
Quick question
if it is set tob Manual, what changes?
Does this just mean that if i have a sum formula in a cell somewhere it won't update if i change a cell its depended on?
or
will it affect calculations in my code, like if I specify,
VariableA = 6*ws.cells(1,1)
Thanks!