| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Return date if in range, else return blank | Excel Worksheet Functions | |||
| return min. of range except 0 | Excel Discussion (Misc queries) | |||
| Return to range | Excel Programming | |||
| Return Range in VB | Excel Programming | |||
| How do I return the name of a Range? | Excel Programming | |||
Hybrid Mode
