Hello Jim,

Tp return the cell address as a string in "A1" style...

Addx = Cells(2, 3).Address

Addx = "C2"

Sincerely,
Leith Ros

--
Leith Ros
-----------------------------------------------------------------------
Leith Ross's Profile: http://www.excelforum.com/member.php...fo&userid=1846
View this thread: http://www.excelforum.com/showthread.php?threadid=48473