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.
Bookmarks