=HYPERLINK("#d1","")
will make the cell blank,
I couldn't find anyway to stop it from defaulting to blue and
underlying, you can format the faont ant colour, but I couldn't get rid
of the underline
Dave


--
davesexcel
------------------------------------------------------------------------
davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708
View this thread: http://www.excelforum.com/showthread...hreadid=516437