I have a Function Call that won't cause calculation.
Unless you declare it Volatile, Excel will only recalculate it when
there are changes to the arguments. Since there are no arguments ...
You will probably get better performance by explicitly passing the cell
dependencies as arguments instead of declaring it Volatile.
Jerry
Mac Lingo wrote:
I have a function which I call from an Excell cell "=GetNote()".
The only way I can get this function to calculate is to explicitly go to the
cell and then hit CR. It doesn't calculate if I do a COPY with the formula
included or if I do a re-calc (F9).
Why isn't this function calculating?
Thanks,
Mac
|