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