Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Run Time Error "28" - Out of stack space?
don't make up variables to use in an event. Costlegend shouldn't be in the
declaration. Use the event as declared by selecting it from the dropdown. Make sure your subs don't cause the event to fire again - such recursive calls can cause an out of stackspace error. This event fires for each sheet calculated. As you said in a previous post, this causes your routine fire multiple times when it isn't necessary. -- Regards, Tom Ogilvy "Dale Cox" wrote in message ... When I Run the routine SheetCalculate, it executes correctly. When I add it as a call in the event Workbook_SheetCalculate, I get the message below. What does it mean, and where can I go to look up these kinds of errors so I can try to debug my own code? Message: Run Time Error "28" - Out of stack space Code: Public Sub Workbook_SheetCalculate(ByVal Costlegend As Object) Call SheetCalculate Call Calc_SVS_Phases End Sub Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Out of Stack Space error | Excel Discussion (Misc queries) | |||
Out of Stack space - run time error 28 | Excel Discussion (Misc queries) | |||
"Out of Stack Space" Macro Error | Excel Discussion (Misc queries) | |||
how do I type "itis" without Excel putting a space "it is"? | Excel Worksheet Functions | |||
"Can't Show Modally" - Run-Time Error '400' Problem | Excel Programming |