In order to optimise the run time of a macro i have written i would lik
to stop the excel worksheet from performing any unnecessar
calculations.

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

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

Thanks



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

Calculation is either on or off (automatic or manual).

It sounds like you want to make it manual

application.Calculation = xlManual

you can then reference any range and force a calculation

range("A1:B20").Calculate

is necessary.
--
Regards,
Tom Ogilvy

"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/

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/