Turn off autocalculate in VBA

[Me]

I have a large spreadsheet that I import a text file into
and then parse some data with. The larger it gets, the
slower it gets. All this is understandable but one of the
things that seems to slow it down is the recalculation of
fields within the sheet. How can I turn this off and on
using VBA?

 

[Frank Kabel]

Hi
use
Application.Calculation = xlCalculationManual
and
Application.Calculation = xlCalculationAutomatic

 

[Erin]

Application.Calculation = xlCalculateManual
Application.CalculateBeforeSave = True

Application.Calculation = xlCalculationAutomatic

HTH

Erin

 

[Tod]

You can put this statement before the code:

Application.Calculation = xlCalculationManual

'code, code, code

'And then:

Application.Calculation= xlCalculationAutomatic

tod