View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Lokesh Sharma Lokesh Sharma is offline
external usenet poster
 
Posts: 1
Default Avoiding Recalculation for a function in automatic mode

I got 2 functions in my Excel func1 and func2 and its running in automatic
mode. Since my excel i s running in automatic mode, both functions are called
again and recalculated.
I would like to avoid recalculating of func1 but would like func2 to
recalculate again.

Is there a way for this?? Since when I set EnableCalculation = True , both
functions are called.