Out of stack space error

I'm running a while loop and after about 3000 iterations get this error:

"Out of stack space"

Any idea why this happens/ how to fix it?

Thanks

The stack is where recursive routines store their active variables when recursed, and each recursion pushes another set of data (stack gets deeper) until things unwind and get taken off.

You have finite space on the stack; if rountines nest too deeply, you run out.

It's what happens if you stack work in an inbox as received and work only on the top item. If you get too far behind, the stack falls over.

The way to fix it is to redesign your code.

Use the collection object and push things to the collection object or to a hash table.

OK, thank you.

I have a master macro that runs a loop of 8,000 iterations or so.

Within the loop, if condition 1 is met, function 1 runs (function 1 is written in another module, outside of master), then returns back to master macro; if condition 2 is met, function 2 runs (function 2 is written in another module, outside of master), then returns back to master macro;

Every time I run this, I get "Out of stack space error" after about 2000 iterations.

If I put the code for function 1 and 2 within the code of master, and run the master, no error pops up. My prefference is to have master and functions 1 and 2 separate.

I'm a bit new to programming - what is the language I need to use to elliminate this error?

Thanks.

Here it is:


Master Macro:

Please Login or Register  to view this content.

Functions 1 and 2:

Please Login or Register  to view this content.

Any luck with this?

Sorry but that code appears to be all over the place.

You seem to be running subs from other subs then calling back to those subs again.

Threads merged. luv2glyd, please don't do that.

Routine A calls B and C
Routine B calls A
Routine C calls A
So the stack gets deeper until it overflows.

I don't think anyone could help without having a clue as to what you're trying to do, and seeing the six missing routines.