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