I have seen a similar problem (is it the same one) If you have
userdefined functions referenced from the worksheet. If the userdefined
functions do not have error trapping in them (on error goto etc) then if
such an untrapped error arises it stops all calculation from that point
on without warning.

They can be really difficult to track down. So put error trapping in
all functions.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=329016