Turn off calculation

Remember to turn it back on as needed.   

‘turn off the calculation
Application.Calculation = xlCalculationManual

Other possible values:

 

If you need to force a calculation use:

   Calculate  
To adjust the calculation on save settings use:

 Application.CalculateBeforeSave = True

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s




%d bloggers like this: