Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges dissapear from list
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges dissapear from list
hi
see this site http://www.homeandlearn.co.uk/excel2...l2007s7p6.html regards FSt1 "Susan" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges dissapear from list
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. "FSt1" wrote: hi see this site http://www.homeandlearn.co.uk/excel2...l2007s7p6.html regards FSt1 "Susan" wrote: 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? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges dissapear from list
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. Susan wrote: 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? -- Dave Peterson |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named ranges dissapear from list
Thanks.
"Dave Peterson" wrote: 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. Susan wrote: 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? -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
named ranges? | Excel Worksheet Functions | |||
Create list of Named Ranges | Excel Worksheet Functions | |||
Named Ranges don't show up in drop-down list | Excel Discussion (Misc queries) | |||
Like 123, allow named ranges, and print named ranges | Excel Discussion (Misc queries) | |||
Viewing List of Named Ranges | Excel Discussion (Misc queries) |