Try

=CELL("address",B3)

where B3 is the cell you want the address for

This will produce $B$3 as the result.


--
SuperDave
------------------------------------------------------------------------
SuperDave's Profile: http://www.excelforum.com/member.php...o&userid=25935
View this thread: http://www.excelforum.com/showthread...hreadid=393272