Just a heads up, but that would produce $C$2

you need Cells(2,3).address(0,0) to get just C2.

--
Regards,
Tom Ogilvy

"Leith Ross" wrote
in message ...

Hello Jim,

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

Addx = Cells(2, 3).Address

Addx = "C2"

Sincerely,
Leith Ross


--
Leith Ross
------------------------------------------------------------------------
Leith Ross's Profile:
http://www.excelforum.com/member.php...o&userid=18465
View this thread: http://www.excelforum.com/showthread...hreadid=484733