Thank you for the replies.

I have a few days off from work...when I return I will try that on the
user's sheet to see what happens.

The only way I could get it to work in the meantime, was to put the
formula on a whole new sheet...and then copy and paste the cell over to
the "wierd" sheet. That worked fine.


--
couriced
------------------------------------------------------------------------
couriced's Profile: http://www.excelforum.com/member.php...o&userid=26900
View this thread: http://www.excelforum.com/showthread...hreadid=473112