Turn off Autocalculate in VBE/VBScript

[Michael]

I have a spreadsheet that sucks in a bunch of text files
and runs some calculations against it. It works great but
now that it's getting a little large it is taking longer
and longer to run. What appears to be happening is that
the Autocalculation is running each time I update a cell,
which is often. I can see the "Calculating Cells: xx%" in
the bottom left of the Excel screen. How do I turn this
off within my script and then turn it on again once I'm
done?

 

[Frank Kabel]

Hi Michael
try the following

Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub

 

[Guest]

THANKS!

-----Original Message-----
Hi Michael
try the following

Sub foo()
Application.ScreenUpdating = False
Application.Calculation = xlCalculationManual
'...
'enter your code
'...
Application.ScreenUpdating = True
Application.Calculation = xlCalculationAutomatic
end sub


--
Regards
Frank Kabel
Frankfurt, Germany

.