please show us your code. Typically this is caused bt calling a subroutine
and not returning correctly.
When a sub i scalled, the return address is pushed onto the stack, and then
this is removed when the sun returns control back ...if this fails, then the
returns build up indefinitely on the stack...this eats memory...and
eventually you get the failure

"Bshawn via OfficeKB.com" wrote:

I am using Excel 2003, and have a spreadsheet with a lot of formulas (Most
cells from a1 to IV1700 have formulas in them). I have the spreadsheet set
to calculate manually. I have a command button that triggers a macro, which
the code in the macro is just the one word "Calculate". If I press F9, the
spreadsheet calculates fine, but if I click on the command button, it gives
me the "Out of stack space" error. How can I fix this? Thanks.

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200909/1