How do I set things up so that a custom function automatically recalculates
when a cell value changes? I have function which calculates a value based on
several cells and need the value updated when the cells change.

In the example below, I need the value in cell A1 to update when the value
of B1, C1 or D1 changes.

Column
Row A B C D
=getDescription() Y N Y

getDescription looks at the values in the cells and returns a string based
on the values found. Should I be passing the values directly into the
function as in

=getDescription(B1, C1, D1)

David H

Hi David,

Yes you should pass the values directly into the functions as arguments:
thats what Excel looks at to determine when to recalculate a function.

Charles
______________________
Decision Models
FastExcel 2.2 Beta now available
www.DecisionModels.com

"dch3" wrote in message
...
How do I set things up so that a custom function automatically
recalculates
when a cell value changes? I have function which calculates a value based
on
several cells and need the value updated when the cells change.

In the example below, I need the value in cell A1 to update when the value
of B1, C1 or D1 changes.

Column
Row A B C D
=getDescription() Y N Y

getDescription looks at the values in the cells and returns a string based
on the values found. Should I be passing the values directly into the
function as in

=getDescription(B1, C1, D1)

David H