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]

Is the first-called event exiting before it's triggered again? Perhaps, instead of taking off again, it can set a condition in a shared variable and exit, and that shared variable tells the parent procedure to call the child procedure again?

If it's still in the child procedure when it's triggered again, I can see why the system is eventually recursing at you. ];-)

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