Return the name of a range
 

Hi all,

I have a problem of returning the name of a range: Here is the problem:

Range("A1").Name = "ABC"
? range("A1").Name
=Sheet1!$A$1

How can I programmatically return the range name of a range in "A1"
notation? Thanks a lot.

Frederick Chow
Hong Kong.

Return the name of a range
 

--
---
Regards,
Norman



"Frederick Chow" wrote in message
...
Hi all,

I have a problem of returning the name of a range: Here is the problem:

Range("A1").Name = "ABC"
? range("A1").Name
=Sheet1!$A$1

How can I programmatically return the range name of a range in "A1"
notation? Thanks a lot.

Frederick Chow
Hong Kong.

Return the name of a range
 

Hi Frederick,

Try:

Range("A1").Name.Name


---
Regards,
Norman



"Frederick Chow" wrote in message
...
Hi all,

I have a problem of returning the name of a range: Here is the problem:

Range("A1").Name = "ABC"
? range("A1").Name
=Sheet1!$A$1

How can I programmatically return the range name of a range in "A1"
notation? Thanks a lot.

Frederick Chow
Hong Kong.

Return the name of a range
 

Thanks very much Norman!

The solution seems really strange. What is the meaning of ".name.name"?
Thanks!

Frederick Chow

"Norman Jones" wrote in message
...
Hi Frederick,

Try:

Range("A1").Name.Name


---
Regards,
Norman



"Frederick Chow" wrote in message
...
Hi all,

I have a problem of returning the name of a range: Here is the problem:

Range("A1").Name = "ABC"
? range("A1").Name
=Sheet1!$A$1

How can I programmatically return the range name of a range in "A1"
notation? Thanks a lot.

Frederick Chow
Hong Kong.

Return the name of a range
 

Hi Frederick,

The solution seems really strange. What is the meaning of ".name.name"?

See VBA help for the Name property:

'===================
Name Property

Returns or sets the name of the object. The name of a Range object is a Name
object. For every other type of object, the name is a string.

'<<===================

---
Regards,
Norman



"Frederick Chow" wrote in message
...
Thanks very much Norman!

The solution seems really strange. What is the meaning of ".name.name"?
Thanks!

Frederick Chow

"Norman Jones" wrote in message
...
Hi Frederick,

Try:

Range("A1").Name.Name


---
Regards,
Norman