View Single Post
  #9   Report Post  
JE McGimpsey
 
Posts: n/a
Default

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?

In article ,
Ola wrote:

Your formula =getcolor(A10) will not recalculate by F9.
It will only recalculate if the actual cell change (F2+Enter, copy/paste).
On the other hand =IF(NOW()0,getcolor(A10),"") will recalculate by F9.
If I knew how, I would include cellcolor in morefunc.xll.