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" <(E-Mail Removed)> wrote in message
news:BO21yJAbS1nCFwb$@sweepdog.home...
> 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" <(E-Mail Removed)> wrote in message
news:BO21yJAbS1nCFwb$@sweepdog.home...
> 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" <(E-Mail Removed)> wrote in message
news:BO21yJAbS1nCFwb$@sweepdog.home...
> 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
<(E-Mail Removed)>) 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