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