"Charles Williams" wrote in message ...
Hi Umf,

its just a UDF so in a worksheet cell put =itertest(c9)
where c9 is one of the cells in your circular reference chain.

Charles
Silly me.... It prints False four times and then prints True for 100
times. It gets called 104 times although Max interations is at 100. I
think you are right on Excel switching it off and on later.

Using your method gets it to work, as in this:
Function Iter_Status(theRange As Range)
Application.Volatile
Dim dblx As Double
dblx = theRange + 1
If Application.Iteration Then
Iter_Status = "True"
Else
Iter_Status = "False"
End If
End Function

The line " dblx = theRange + 1" is crucial, without it, it is only
called in the first iteration, where it returns false (but you knew
that I guess).

It is still a bit of a prob for me, as all the iterations are made
only if iteration is on and a boolean swithc is on for each
"transaction"....which the user can turn on or off to gain speed if
they do not need all the transactions calculated in this way. So I'd
rather know whether Excel would try to iterate, given circular
references, then whether Excel actually *does* iterate...

But this is very helpful already. I'll just have to do your test on
all individual iteration-sections. If they are all turned off on the
spreadsheet I might still get a false while it is true, but I guess
I'll have to live with it...

Thanks a lot. :up: