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?

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?

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?

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

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