enter the word volitile at the begining of the macro

"Brite" wrote:

Hi there,

I'm created a function using macros, and i want to know how to make it so
that when ever something on the worksheet changes the function will
recalculate and update itself. How do I go about doing this?

thanks in advance

Ryan