Barb -

You may be able to avoid using application.volatile if your function has an
argument that refers to those cells that are changing.

- Mike
http://www.mikemiddleton.com

"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