Calculation toggle

  • Thread starter Thread starter JP
  • Start date Start date
J

JP

Hello,

Is there a property or method that returns the current calculation
state (xlcalculationmanual, automatic etc)?

Tried searching but can't seem to locate this anywhere.


Thx!

--JP
 
Thank you, I ended up using this code:

' get current calculation mode and store as variable, then set it to
manual for faster code
X = Application.Calculation
Application.Calculation = xlCalculationManual
'
' my code here
'
' set calculation to whatever it was before
Application.Calculation = X


Thx,
JP
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Problem setting the State of a custom Toolbar button 4
Application.Calculation = xlCalculationManual not working 5
Found where program stops, but can't stop it stopping !! 3
manual/auto calculation toggle button 1
Toggle Calculation Status 5
Calculation mode 4
Command to toggle Control Toolbox on? 1
Calculate Cells - Time consuming! 1

Back
Top