|
CALCSEQCOUNTREF Function
CalcSeqCountRef returns the value of the calculations counter, and is dependent on a cell reference, so you can use it to count the number of times a cell is calculated.
CalcSeqcountRef Syntax
CalcSeqCountRef (theRange)
theRange
A reference to an excel cell. At each recalculation Excel will calculate CalcSeqCountRef if the cell referred to by theRange has changed or been recalculated.
CalcSeqCountRef Remarks
The function uses a single global calculation counter, so a workbook containing multiple formulas containing CalcSeqCountRef will show the sequence in which they were calculated.
Entering CalcSeqCountRef into a cell using the Function Wizard/Palette will increment the calculation counter several times because the Function Wizard attempts to show you the result of the function at each step.
To reset the calculations counter either run the ZeroCalcSeq macro from Toolsacros, or use the CalcSeqCountSet function.
See also the CalcSeqCountVol function, which is a volatile function which increments the same calculations counter.
|
