How can I convert numeric format into a range? 2

[JensKKK]

Hi

I would like to convert a numeric cell address such as sheets1.cells(1,1) into the corresponding range(A1). Is there any VB command around for that or do I have to write my on function for that?

Any help appreciated.

 

[PHV]

Have a look at the Address property of the Range object.

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JensKKK]

PHV (MIS)
11 Jul 07 6:28
Have a look at the Address property of the Range object.

PHS, could you expand a little bit more on that topic.

Does that mean there is no VB command in Excel to convert cell co-ordinates into lets call it range co-ordinate system.

Thanks

 

[PHV]

A starting point:
MsgBox Cells(1, 1).Address(False, False)

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[JensKKK]

Ahhh

Thanks for pointing me in the right directions.

R

Jens