| Home |
| Search |
| Today's Posts |
|
#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 |
| 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 | |||
Threaded Mode
