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