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

doent recalculate on save 4
Defining a range as a subset of cells in another range 12
copy then paste to multiple ranges 3
Restrict cells selected to specific range name 1
Recalculate Named Range After Sheet Changes 1
Array formulae do not recalculate 2
Assigning range to variant 2
Total Value of a Range 4

Top