Maximum Iterations

[less33]

I use Excel 2007 to do fairly complex iterative calculations. Based on
the specifications posted on the Microsoft website, the maximum number
of iterations is limited to 32767. Many of my calculations take
several hundred iterations to complete which requires me to stare at
the screen and press the F9 key every minute of so. It is rather
tedious to say the least!

Is there any clever way to force Excel to iterate until the specified
maximum change is reached rather than stopping after 32767 iterations?
Maybe a creative bit of VB code?

 

[Zaidy036]

I use Excel 2007 to do fairly complex iterative calculations. Based on
the specifications posted on the Microsoft website, the maximum number
of iterations is limited to 32767. Many of my calculations take
several hundred iterations to complete which requires me to stare at
the screen and press the F9 key every minute of so. It is rather
tedious to say the least!

Is there any clever way to force Excel to iterate until the specified
maximum change is reached rather than stopping after 32767 iterations?
Maybe a creative bit of VB code?

If no suggests a macro or VBA then have a look at AutoIt, PBFB, or similar.

 

[Michael Bednarek]

[snip]

Is there any clever way to force Excel to iterate until the specified
maximum change is reached rather than stopping after 32767 iterations?
Maybe a creative bit of VB code?

A variation of this might work:

While something <> another
ActiveSheet.UsedRange.Calculate
Wend