View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bshawn via OfficeKB.com Bshawn via OfficeKB.com is offline
external usenet poster
 
Posts: 2
Default Runtime Error 28 - Out of stack space

That worked! Thanks.

Dave Peterson wrote:
Just a guess...

I'm guessing that you have a worksheet_calculate or Workbook_SheetCalculate
event that's firing because of the calculation and it may be calling other
events that call themselves or the _calculate event.

I'd try:

Sub yourmacronamehere()
with application
.enableevents = false
.calculate
.enableevents = true
end with
end sub

But it's just a guess.

The .enableevents tells excel to stop looking for triggers that cause events to
fire.

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

[quoted text clipped - 6 lines]
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200909/1



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