I want a range not to recalculate

D

Dan

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
 
C

Charles Williams

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Recalculation Failure 1
copy then paste to multiple ranges 3
Restrict cells selected to specific range name 1
complex problem 0
doent recalculate on save 4
How can i find the max value within a time range ased on two cells 6
How to force user function to recalculate 5
Volatility, recalculation 7

Top