Thank you both for your responses. Both methods work. I went with
Application.Volatile (True is implied), as there is less clutter in the cell.

"Oliver Ferns via OfficeKB.com" wrote:

Try putting

Application.Volatile True

In your UDF.

Hth,
Oli

--
Message posted via http://www.officekb.com