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.
|