Correct.
Not possible with a worksheet function.

NickHK

"dec_obrien" wrote
in message ...

Thanks guys, Application.Caller.Address gets teh address of the cell but
it won't change the format of the cell.


--
dec_obrien
------------------------------------------------------------------------
dec_obrien's Profile:
http://www.excelforum.com/member.php...o&userid=37705
View this thread: http://www.excelforum.com/showthread...hreadid=572994