LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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.
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Need some comments on my Utility_Move class module. jchen Excel Worksheet Functions 0 August 21st 06 07:05 PM
weird recalculation of user defined function timspier Excel Worksheet Functions 3 May 14th 06 05:39 AM
numerical integration integreat Excel Discussion (Misc queries) 4 May 12th 06 02:40 AM
Custom function Christina L. Excel Worksheet Functions 1 May 10th 06 06:38 PM
MODE function Dobbie22 Excel Worksheet Functions 2 December 10th 04 04:13 PM


All times are GMT +1. The time now is 01:41 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"