Thread: "Out of Stack Space" Macro Error
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.misc
Stephen Bye Stephen Bye is offline
external usenet poster
  
Posts: 28
Default "Out of Stack Space" Macro Error
Because your routine is calling itself recursively.
Try:

Sub Calculate()
Application.Calculate
End Sub

or:

Sub MyCalculate()
Calculate
End Sub

instead.


Reply With QuoteReply With Quote