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" <(E-Mail Removed)> wrote in message
news:(E-Mail Removed)...
> 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" <Char...@DecisionModels.com>
wrote:
> Application.calculation
>
> "JP" <jp...@sterlingtesting.com> wrote in message
>
> news:(E-Mail Removed)...
>
>
>
> > 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 -