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