Don't know if this is appropriate but you can set calculation to
manual and use the Calculate Method on a specific Worksheet or Range
(see VB Editor help).

REgards
BrianB
=================================================

nigelbellamy wrote in message ...
In order to optimise the run time of a macro i have written i would like
to stop the excel worksheet from performing any unnecessary
calculations.

My macro is altering the values in many cells in a worksheet. These
cells are then the basis for a secondary set of calculations, both on
the same worksheet and another worksheet.

Is there a way of specifying which of cells or links that are dependent
on the cell that the macro is altering should be refreshed every time
that particular cell is altered?

Thanks

N


---
Message posted from http://www.ExcelForum.com/