Named ranges dissapear from list

  • Thread starter Thread starter Susan
  • Start date Start date
S

Susan

I created several named ranges with workbook scope. Then I decided to change
some of them to dynamic ranges (using the offset and counta functions). When
I work with them from the Name Manager, they are visible and select the
proper cells. When I close the Name Manager and try to select the range by
using the drop down list below the ribbon (sorry, I don't know what this is
called), the changed range names are no longer there. Where did they go?
 
Thanks for the info. However, when I open the Apply Names box, none of the
dynamic range names are in the list -- only the static ones.
 
That's the way excel works.

But you can type those names into the namebox and hit enter if you want to
select the range.
 
Thanks.

Dave Peterson said:
That's the way excel works.

But you can type those names into the namebox and hit enter if you want to
select the range.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Range Name Scope 4
How do I set up a Dynamic Named Ranges in Excel 2007 7
Named Range maker code 9
Dependent drop down dynamic range formula, off sheet. 7
Dynamically Naming a Table of Data 2
Changing named Validation list to Dynamic list. 1
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Dynamic named range reference from external workbook 2

Back
Top