turning auto calculate on and off
 

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

turning auto calculate on and off
 

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

"Bart van den Burg" wrote in message
...
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