Hi
yes: best way would to include all used cells as aparemeter in your
function. Don't hardcode cell references within your function

--
Regards
Frank Kabel
Frankfurt, Germany

"Bill Buckner" schrieb im
Newsbeitrag ...
pikus,

Not sure I understand your suggestion. The functions do not update
the entire worksheet. They are called directly by cells and are used
in the calculation of those cells. For instance:

=ROUND(calcAnnuity("Primary", A7)+calcAnnuity("Spouse", A7),0)

Where calcAnnuity is my custom function.

I don't really want the worksheet to go through a complete
recalculation every time the function is called, but I do want cells
based upon cells which call the custom function to be recalculated when
I change a value from which the custom function gets data.

Would I be better off passing the cell references an an argument to
the custom function instead of using "Range" to retrieve valuse in the
function itself? Would this be recognized as a change by Excel?

I don't really understand the recalculation rules very well,
especially when I write a custom function.