"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