View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Norman Jones Norman Jones is offline
external usenet poster
 
Posts: 5,302
Default 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.