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.