Can you retrieve the name of a named range?

[reneuend]

I would like to be able to retrieve the name of a named range using the range that it defines. Is this possible?

In other words, if I know the range, but not the defined name for it, can I retrieve the name?


Thx,
~reneuend

 

[mirabeau]

not as simple as selecting the range and noting the name that appears in the name box at top left of your worksheet?

or you can use VBA, either for the selection or the name determination

 

[VoG]

Maybe

MsgBox ActiveCell.Name.Name

 

[reneuend]

Thanks for the replies. Sorry for the confusion. Yes, I'm using VBA. I'll try out your solution VOG. I do have a back up plan if this doesn't work, but it's not as clean.

Much appreciated!

 

[pedie]

"m not sure why you're trying to do this?
In excel 2007, we can simply click on Formula tab > click on "Use in formula" > paste names to get all the names defined.

[/FONT]
[FONT=Courier New]Option Explicit
Sub try()
    Selection.ListNames
End Sub

Just adding to the thought.