Try putting

Application.Volatile

in your function. This will cause the function to recalculate whenever
anything on the sheet calculates.

Col


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