Catch name of range

[Steven]

If a user choses a range in the Name Box is there a way to catch that range
in a variable after selected?

Thank you,

Steven

 

[JLGWhiz]

What do you mean by choosing a range in the Name Box?

You can set a named range to a variable just like any other range.

Set myVar = Range("myNamedRange")

See VBA help titles Referring to Named Ranges

 

[Steven]

The Name Box to the left of the Formula Bar. If the user selects a range
from the Name Box I want to catch the name in a variable.

 

[Gary Keramidas]

if they've actually clicked it to select the range:

rngname = selection.name.name

 

[Bob Phillips]

Try

Selection.Name.Name

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)