Hi all
I have encountered strange problem with named ranges, some named ranges are visible in navigation, but others are not. All named ranges are scoped to workbook (according name manager).
What leads to this? I have excel template with named ranges, to this template executable VB.NET code send lot of values via VBA macro. After executable has finished macro calls, excel template is show to user with values visible, cells formatted and named ranges in use. After this has some things to do, one of those is to press button which saves some parts of generated excel to network drive. On this save half of sheets are copy pasted to new workbook and this new workbook is saved and closed.
When this saved workbook is opened, like one third of named ranges are visible in navigation drop down (or name show when going directly to cell). However, if I go to Name Manager, click named range, click Edit, and click Ok, named range becomes visible in navigation, and I can use it on macros and formulas.
When macro creates new workbook it just creates new sheet, names it, and uses VBA's copy / paste for copying.
Can some one please help me to determine how to fix this, or at least give work around.
I have encountered strange problem with named ranges, some named ranges are visible in navigation, but others are not. All named ranges are scoped to workbook (according name manager).
What leads to this? I have excel template with named ranges, to this template executable VB.NET code send lot of values via VBA macro. After executable has finished macro calls, excel template is show to user with values visible, cells formatted and named ranges in use. After this has some things to do, one of those is to press button which saves some parts of generated excel to network drive. On this save half of sheets are copy pasted to new workbook and this new workbook is saved and closed.
When this saved workbook is opened, like one third of named ranges are visible in navigation drop down (or name show when going directly to cell). However, if I go to Name Manager, click named range, click Edit, and click Ok, named range becomes visible in navigation, and I can use it on macros and formulas.
When macro creates new workbook it just creates new sheet, names it, and uses VBA's copy / paste for copying.
Can some one please help me to determine how to fix this, or at least give work around.
