Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named range is hidden when using OFFSET()
Hello all,
When I create an dynamic named range using the OFFSET() function, the name is hidden from the Name drop-down box (next to the formula bar). The problem is that name is also hidden from SSIS Packages when trying to import into SQL Server. How can I create a dynamic named range where the name is visible from the Name drop-down box and in SSIS Packages. Thanks for any help anyone can provide, Conan Kelly |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Named range is hidden when using OFFSET()
hi
a dynamic named range and a named range are two different things. the dynamic named range as you discribed will always be "hidden". accually it's not hidden. it just doesn't show anywhere except your forumula and can be referenced by other formulas. to have a named range, high light your range and type the name in the name box or on the menu bar... insertnamedefinetype in your nameclick addclick ok. the name will appear in the name box and is not hidden from the SSIS Packages Regards FSt1 "Conan Kelly" wrote: Hello all, When I create an dynamic named range using the OFFSET() function, the name is hidden from the Name drop-down box (next to the formula bar). The problem is that name is also hidden from SSIS Packages when trying to import into SQL Server. How can I create a dynamic named range where the name is visible from the Name drop-down box and in SSIS Packages. Thanks for any help anyone can provide, Conan Kelly |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Sumproduct Indirect Named Dynamic Range using Offset | Excel Worksheet Functions | |||
named range row offset | Excel Worksheet Functions | |||
Dynamic named range & Offset | Excel Discussion (Misc queries) | |||
Offset delivers value error with Named range | Excel Worksheet Functions | |||
named range, offset self-reference | Excel Discussion (Misc queries) |