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