The calculations aren't occuring in VBA but in various formulas embeded in
linked cells.
--
Thanks
Shawn


"Norman Jones" wrote:

Hi Shawn,

If not aleady doing so, wrap your code something like:

Dim CalcMode As Long

With Application
CalcMode = .Calculation
.Calculation = xlCalculationManual
.ScreenUpdating = False
End With

Cells.PageBreak = xlPageBreakNone

'Your code


With Application
.Calculation = CalcMode
.ScreenUpdating = True
End With

I assume that your code is written to avoid selections.

For specialist advice and information on matters pertaining to calculation,
visit Charles Williams's DecisionModels site at:

http://www.decisionmodels.com/optspeedd.htm

---
Regards,
Norman



"Shawn" wrote in message
...
I have a workbook that, at certain times, has to make several thousand
calculations. I could just about go to lunch by the time this process
completes. Is there some simple way to speed this up? It seems like I
recall an article some place called a million calculations in a few
seconds????


--
Thanks
Shawn