|
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?
|