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?