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?

counting iterations
 

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" wrote in message
...
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?

counting iterations
 

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

--
Regards,
Tom Ogilvy


"Mitch" wrote in message
...
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?