Then I don't understand why you can't use the subroutine.

If you can't use a built in formula, I would expect that you wouldn't want to
use a user defined function.


crabtrees wrote:

Sorry...I need to keep the reference out of the cell so that it can't be
written over.

Thanks.

--
crabtrees
------------------------------------------------------------------------
crabtrees's Profile: http://www.excelforum.com/member.php...o&userid=37611
View this thread: http://www.excelforum.com/showthread...hreadid=572785

--

Dave Peterson