Hi. In VBA, if the current Application.Calculation mode is set to
xlCalculationManual, does setting it to xlCalculationAutomatic force a recalc
of any pending changes to the workbook or do I need to explicitly call
Application.Calculate() ?

Many thanks

kh

setting to Automatic will cause a Recalc if there are any volatile or
uncalculated cells.

Charles
______________________
Decision Models
FastExcel 2.3 now available
Name Manager 4.0 now available
www.DecisionModels.com

"kh" <(E-Mail Removed)> wrote in message
news:291545CA-A7DB-4922-8703-(E-Mail Removed)...
> Hi. In VBA, if the current Application.Calculation mode is set to
> xlCalculationManual, does setting it to xlCalculationAutomatic force a
> recalc
> of any pending changes to the workbook or do I need to explicitly call
> Application.Calculate() ?
>
> Many thanks
>
> kh
>

Many thanks



"Charles Williams" wrote:

> setting to Automatic will cause a Recalc if there are any volatile or
> uncalculated cells.
>
> Charles
> ______________________
> Decision Models
> FastExcel 2.3 now available
> Name Manager 4.0 now available
> www.DecisionModels.com
>
> "kh" <(E-Mail Removed)> wrote in message
> news:291545CA-A7DB-4922-8703-(E-Mail Removed)...
> > Hi. In VBA, if the current Application.Calculation mode is set to
> > xlCalculationManual, does setting it to xlCalculationAutomatic force a
> > recalc
> > of any pending changes to the workbook or do I need to explicitly call
> > Application.Calculate() ?
> >
> > Many thanks
> >
> > kh
> >
>
>
>