Try...

=IF(A1<"",CELL("address",A1),"")

...which will return $A$1, or try...

=IF(A1<"",ADDRESS(ROW(A1),COLUMN(A1),4),"")

...which will return A1.

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=379077