counting iterations

I have inherited a workbook that uses an iterative approach to resolve
circular references. I need to record the number of iterations used to
resolve the circular reference, but I cannot find a VBA method/property/etc.
that can report the number of iterations used. It must be in there
somewhere! Can anyone help me?

I think you need to use a calculation counter: you can download
CalcTrace.zip from my downloads page
http://www.DecisionModels.com/downloads.htm

You would need to use the CalcSeqCountRef function referring to one of the
cells in the circular reference loop.
Note that the number of calculations reported should be 1 larger than the
number of iterations.

You may also find it useful to read the description of how excel performs
circular reference calculations at
http://www.decisionmodels.com/calcsecretsc.htm

and some comments on circular references at
http://www.decisionmodels.com/calcsecretsk.htm


Charles
______________________
Decision Models
FastExcel 2.1 now available
www.DecisionModels.com

"Mitch" <Mitch@discussions.microsoft.com> wrote in message
news:FA11EB6E-48AD-498B-B677-742797D60E8B@microsoft.com...
>I have inherited a workbook that uses an iterative approach to resolve
> circular references. I need to record the number of iterations used to
> resolve the circular reference, but I cannot find a VBA
> method/property/etc.
> that can report the number of iterations used. It must be in there
> somewhere! Can anyone help me?

Excel doesn't report that. You can see the maximum allowed in
Tools=>References, Calculation tab.

--
Regards,
Tom Ogilvy


"Mitch" <Mitch@discussions.microsoft.com> wrote in message
news:FA11EB6E-48AD-498B-B677-742797D60E8B@microsoft.com...
> I have inherited a workbook that uses an iterative approach to resolve
> circular references. I need to record the number of iterations used to
> resolve the circular reference, but I cannot find a VBA
method/property/etc.
> that can report the number of iterations used. It must be in there
> somewhere! Can anyone help me?