View Single Post
  #10   Report Post  
 
Posts: n/a
Default

JE McGimpsey wrote...
If you're going to make the overall function volatile anyway, wouldn't


it be more efficient to use

=GetColor(A10)

and put

Application.Volatile

in GetColor(), and avoid the extra function calls?


This is a trade-off. If one puts Application.Volatile in the function,
then it's always volatile. If one only needs a few calls to be
effectively volatile, then that may be accomplished using Ola's trick,
though I prefer something like =f(x)+0*NOW() or =f(x)&LEFT(NOW(),0)
depending on what f() returns.