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

Application.calculation

"JP" wrote in message
ps.com...
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


On Oct 11, 9:27 am, "Charles Williams"
wrote:
Application.calculation

"JP" wrote in message

ps.com...



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- Hide quoted text -

- Show quoted text -