User defined functions

[Andy Ives]

can anyone tell me why I cannot get user defined functions
that are called from a worksheet formula to recalculate
when the spreadsheet updates please?

Cheers

Andy

 

[Bob Umlas]

After the first line of the function put:
Application.Volatile True
to have it calculate when ws calculates.
Bob Umlas
Excel MVP

 

[Andy]

Thanks Bob. I'll give that a try.

Andy

-----Original Message-----
After the first line of the function put:
Application.Volatile True
to have it calculate when ws calculates.
Bob Umlas
Excel MVP




.

 

[Charles Williams]

Excel recalculates UDFs when one of their input arguments change or when
they are volatile.

Best solution is to put all the cells etc that are referenced by the UDF as
arguments to the function. That way the function only gets recalculated when
it needs to.
next best (but simplest) is to add application.volatile which makes the
function always recalculate even when it does not need to.


regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm