View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frederick Chow Frederick Chow is offline
external usenet poster
 
Posts: 75
Default 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.