Of course, you should have posted your code for comments. Put this line as
the FIRST line in your function.

application.volatile


--
Don Guillett
SalesAid Software

"Barb Reinhardt" wrote in message
...
I have created a user defined function and I need to know how to get it to
update automatically or is this not possible. I have some fixed values
for
the input variables and it's pulling data from other sheets that update
from
time to time. Do I need to change the input variables each time to get
it
to update?

Thanks,
Barb Reinhardt