I want a range not to recalculate
 

Hi,
I know how to make a range recalculate on demand by:
Application.Range("A1:B10").Calculate

But I want the opposite:
I need my application to be on Automatic update but not recalculte a
specific range of ("A1:B10") every time a recalc is done.
Any idea?

Many thanks,
Dan

I want a range not to recalculate
 

There is no way to disable calculation for a set of formulae in a range
(although you can disable calculation for a whole sheet by setting
Sheet.EnableCalculation=False), so you could either:

Store the formulae for A1:B10 somewhere as text
then Pastespecial Values A1:B10
Then restore the formulae whenever you want to recalculate A1:B10

or move the A1:B10 range to a separate sheet and use
..EnableCalculation=False for that sheet

Charles
________________________
The Excel Calculation Site
http://www.decisionmodels.com

"Dan" wrote in message
...
Hi,
I know how to make a range recalculate on demand by:
Application.Range("A1:B10").Calculate

But I want the opposite:
I need my application to be on Automatic update but not recalculte a
specific range of ("A1:B10") every time a recalc is done.
Any idea?

Many thanks,
Dan