Neater way of getting "name" of cell?

[XmisterIS]

I'm not sure what you would call it ... "name"? "index"? "grid reference"?

Anyway, here's what I mean:

Let's say I select a cell thus:

Set mycell  = Cells(20, 42)

This is cell "AP20"

Let's say I now pass mycell to a function as an argument.

How to I get the name/index/grid reference (whatever it is called) "AP20" from the object mycell?

[XmisterIS]

I'm not sure what you would call it ... "name"? "index"? "grid reference"?

Anyway, here's what I mean:

Let's say I select a cell thus:

Set mycell  = Cells(20, 42)

This is cell "AP20"

Let's say I now pass mycell to a function as an argument.

How to I get the name/index/grid reference (whatever it is called) "AP20" from the object mycell?

I can do it thus:

cellName = Chr$(mycell.column + 64) & CStr(mycell.Row)

But is there a neater way?

[LJMetzger]

Hi X,

Try:

cellName = mycell.Address(False,False)

The 'False' statements inhibit the '$' from appearing in the string.

Lewis

[Richard Buttrey]

Unfortunately this is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

Please note

Thread Closed.

[Izandol]

mycell.Address(0,0)

for example.

[Leith Ross]

Hello XmisterIS,

You can use the Address property. Your variable has been assigned to a Range object.

    CellName = mycell.Address

[XmisterIS]

tnanks both!

[Fotis1991]

I merged the two same threads...