In the first line of the function put

Application.Volatile

Put error handling in your function as well.

--
Regards,
Tom Ogilvy

"Juggernnath" wrote in message
...
Stupid question, but anyway - I tested my function, and it had some
errors.
Any time I made some changes to VBA code, function didn't refreshed in
Worksheet so I had to write a function again in the cell. How can I avoid
this, so result will change in the cell anytime I change a function in
VBA?