View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
dan dan is offline
external usenet poster
 
Posts: 866
Default 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