Range Names

  • Thread starter Thread starter JMay
  • Start date Start date
J

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,
 
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)
 
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.
 
Yes, that too.. Tks Paul

Paul said:
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.
Click to expand...
 
Back
Top