You could either make your function volatile by adding

Application.Volatile

to it's code, thus making it recalculate when any other function does,
or use the Calculate method of the Workbook, Worksheet or Range in
which your function appears, e.g.

Application.Calculate


Col


--
colofnature
------------------------------------------------------------------------
colofnature's Profile: http://www.excelforum.com/member.php...o&userid=34356
View this thread: http://www.excelforum.com/showthread...hreadid=548894