Return the name of a range

[Frederick Chow]

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.

 

[Norman Jones]

--

 

[Norman Jones]

Hi Frederick,

Try:

Range("A1").Name.Name

 

[Frederick Chow]

Thanks very much Norman!

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

Frederick Chow

 

[Norman Jones]

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.

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