Hi Number1 and welcome to the forum.

Look http://msdn.microsoft.com/en-us/libr...ffice.11).aspx

Put Application.Volatile in the first line after the UDF name.

hope that works.