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

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

--
Regards,
Tom Ogilvy

"Philip Wilson" wrote in message
...
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