Is there a function I can use to display to the user the address
corresponding to the cells coordinate of row,column? for example if I am
working with a cell at 2,3 is there a functio to convert it to address c2 ?

thanks

msgbox cells(2,3).address(0,0)

If I understand what you mean.

Jim wrote:

Is there a function I can use to display to the user the address
corresponding to the cells coordinate of row,column? for example if I am
working with a cell at 2,3 is there a functio to convert it to address c2 ?

thanks

--

Dave Peterson

thanks, that was it.

"Dave Peterson" wrote in message
...
msgbox cells(2,3).address(0,0)

If I understand what you mean.

Jim wrote:

Is there a function I can use to display to the user the address
corresponding to the cells coordinate of row,column? for example if I am
working with a cell at 2,3 is there a functio to convert it to address c2
?

thanks

--

Dave Peterson

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

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