View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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.