Are there any limits to the depth level of recursion, or is it
determined by memory

Are there any functions you can call like you can in 'C' to see if
you'll have enough free memory to allocate a whole stash of stuff??
--
Mike

It is limited by the amount of stack space. To the best of my knowledge,
this is fixed and can not be queried as to how much is used and how much
remains available.

--
Regards,
Tom Ogilvy


"Mike NG" wrote in message
...
Are there any limits to the depth level of recursion, or is it
determined by memory

Are there any functions you can call like you can in 'C' to see if
you'll have enough free memory to allocate a whole stash of stuff??
--
Mike

Hi Mike,

AFAIK, no such limit has been published.
I have several functions in which the level of recursion is 100 (Markov
chains for disability insurance) and have not experienced any problems so
far.

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Mike NG" wrote in message
...
Are there any limits to the depth level of recursion, or is it determined
by memory

Are there any functions you can call like you can in 'C' to see if you'll
have enough free memory to allocate a whole stash of stuff??
--
Mike

"Mike NG" wrote in message
...
Are there any limits to the depth level of recursion, or is it determined
by memory

Are there any functions you can call like you can in 'C' to see if you'll
have enough free memory to allocate a whole stash of stuff??

Hi Mike,

Depth of recursion is limited by Excel's available stack space. There
isn't any way to determine the amount of stack space available. There's a
VBA call you can use to determine the amount of system memory available
(Application.MemoryFree), but this reports available system memory, not
internal stack space available.

--
Rob Bovey, Excel MVP
Application Professionals
http://www.appspro.com/

* Take your Excel development skills to the next level.
* Professional Excel Development
http://www.appspro.com/Books/Books.htm

On Thu, 2 Jun 2005 at 21:24:54, Niek Otten (Niek Otten
) wrote:
Hi Mike,

AFAIK, no such limit has been published.
I have several functions in which the level of recursion is 100 (Markov
chains for disability insurance) and have not experienced any problems so
far.

Great - that should more than cover it then
--
Mike