Macro error stack full

P

Philip Wilson

When running a macro I get the error stack full and the macro stops. I can
then restart the macro and it starts back where it left off and completes.
How can I eliminate the stack full error, what is causing this. The macro
is building a spreadsheet that take one input line and creates an output
transaction spreadsheet that has 6 detail row for each input row.

Phil
 
T

Tom Ogilvy

Are you recursively calling the code - does your code call itself. If so,
try going to a non-recursive design.
 
Top