getting the named cell
 

If I want to get the named cell,
For instance D5 is mycell1
If I have
Dim objRange As Excel.Range
Set objRange = Range("D5")

Can I get the name of the cell?

If I do this:
objRange.ListNames
it puts the name of the cell in the text area. Quite strange.
But, any way to get the named cell?
thanks

getting the named cell
 

sNm = objRange.Name.Name

You'll probably want to do that under an error handler in case the range is
not named.

Regards,
Peter T

"greg" wrote in message
...
If I want to get the named cell,
For instance D5 is mycell1
If I have
Dim objRange As Excel.Range
Set objRange = Range("D5")

Can I get the name of the cell?

If I do this:
objRange.ListNames
it puts the name of the cell in the text area. Quite strange.
But, any way to get the named cell?
thanks

getting the named cell
 

thanks. it works.
name.name is kinda strange

"Peter T" <peter_t@discussions wrote in message
...
sNm = objRange.Name.Name

You'll probably want to do that under an error handler in case the range
is
not named.

Regards,
Peter T

"greg" wrote in message
...
If I want to get the named cell,
For instance D5 is mycell1
If I have
Dim objRange As Excel.Range
Set objRange = Range("D5")

Can I get the name of the cell?

If I do this:
objRange.ListNames
it puts the name of the cell in the text area. Quite strange.
But, any way to get the named cell?
thanks