How to make user defined functions recalculate automatically


Posted by Juan Pablo on September 06, 2001 8:46 AM

Hi,

I created a function that can be used directly in Excel, but when i change one of the depending cells, the result is not updated automatically, why is that ? am i doing something wrong ?

I put the formula in a Module in the activeworkbook.



Posted by Dax on September 06, 2001 9:17 AM

Put Application.Volatile at the start of your function.

Dax.