Range Names

[JMay]

What distinguishes a named range from being viewed:
1) In the NameBox (theDrop-down box - to left of the formula bar)
Versus
2) By doing Control+F3 (equivalent to Insert, Name, Define...)
TIA,

 

[Chip Pearson]

I'm not exactly sure what your question is, but names that refer to formulas
or constants are not displayed in the Names box, but are displayed in the
Names dialog. Beyond that, I think the two behave the same. Perhaps you
could be a bit more specific?


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)

 

[JMay]

No, you hit on it. It was just near-idle curiosity;
Thanks Chip

 

[Paul]

Maybe the OP is thinking about dynamic range names, defined by a formula
such as
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
which do not appear in the Name Box.

 

[JMay]

Yes, that too.. Tks Paul

Maybe the OP is thinking about dynamic range names, defined by a formula
such as
=OFFSET(Sheet1!$A$1,0,0,COUNTA(Sheet1!$A:$A),1)
which do not appear in the Name Box.