All cells that the function depends on should be in the argument list of the
function definition and call.
Sometimes, including "Application.Volatile" in the function header is
suggested as a solution.
However, there is no certainty that this will cause the cells to calculate
in the correct sequence and will keep to do so in future versions of Excel,
because this behavior is not part of the specifications of Excel. It also
causes many unnecessary recalculations of the function.
The only correct way is to include all precedent cells in the argument list

--
Kind regards,

Niek Otten

"Egon" wrote in message
oups.com...
I have two custom functions in a workbook. The problem is, they don't
seem to update themselves until I go into the cell and click in the
formula somewhere and then hit Enter.

How do I make them update themselves automatically?

Thanks
J.