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

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" wrote:

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

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.

"JLGWhiz" wrote:

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" wrote:

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

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

rngname = selection.name.name

--


Gary


"Steven" wrote in message
...
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

Try

Selection.Name.Name

--
---
HTH

Bob


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



"Steven" wrote in message
...
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.

"JLGWhiz" wrote:

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" wrote:

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