Or Maybe I Can't Do This

[rowyn]

Hrmph. My report gets through about 10 iterations, then crashes with a stack-overflow error. Which appears to be caused by Excel VBA call stack filling up with my auto-generated macro calls. Googling about for "how to clear the call stack" has not made me optimistic about my odds of getting around this via VBA.  x.x

Comments

[level-head.livejournal.com]

It may be that your procedure is calling itself. If that's the case, you can have a parent procedure that calls the child one over and over, so the child one exits each time and clears its stack.

===|==============/ Keith DeHavelle