Preventing linked cells from updating

  • Thread starter Thread starter nigelbellamy
  • Start date Start date
N

nigelbellamy

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
 
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.
 
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
=================================================
 
Back
Top