turning auto calculate on and off

[Bart van den Burg]

Hi

I wish to turn auto calculate off before letting a script fill a lot of
field, because it saves a lot of time, but i would prefer it, if this could
automatically be done in the script, as well as turning it on after the
function. Is there anyway to do this?

Thanks
Bart

 

[N10]

Hi this might help

Application.Calculation = xlCalculationManual
' ooo Your code here ooo
Application.Calculation = xlCalculationAutomatic

from

http://www.mvps.org/dmcritchie/excel/slowresp.htm

BEst N10