Dave,

As far as I know, there is no way to increase stack size. You'll have to
rewrite the code in such as way that it doesn't fill up the stack, e.g.,
eliminating so much recursion.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com

"Dave Ring" wrote in message
...
Not infrequently, I run into "Out of stack space" run time errors when
running recursive routines. Is there any solution to this other than
eliminating recursion and rewriting the code with my own stack? Is
there, for instance, some way to allocate more room for the VBA call
stack?

Dave Ring