Posted to microsoft.public.excel.programming

Bura Tino

external usenet poster

Posts: 57

Making a function somewhat volatile.

Hi,

Suppose my function makes a reference to a range (named "MyRange"). So, in a
way, the function depends on it. Is there a way to cause the function to
recalculate when the vlaue of "MyRange" changes? I don't want to make
volatile since too many cells depend on it and "MyRange" changes
infrequently.

Thanks!

Bura

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

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
Would like help making a function	Sarah H.[_2_]	Excel Discussion (Misc queries)	4	November 16th 09 04:14 PM
Today - volatile function	dhstein	Excel Discussion (Misc queries)	5	May 25th 09 03:12 PM
is MATCH a volatile function?	Dave F	Excel Discussion (Misc queries)	3	January 31st 07 07:05 PM
why is the INDIRECT function volatile?	Dave F	Excel Worksheet Functions	2	October 25th 06 02:10 PM
Application.Volatile messing up other function	itchyII	Excel Programming	1	April 1st 04 04:31 PM

All times are GMT +1. The time now is 04:13 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us