Named range is hidden when using OFFSET()

C

Conan Kelly

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
 
G

Guest

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...
insert>name>define>type in your name>click add>click ok.
the name will appear in the name box and is not hidden from the SSIS Packages

Regards
FSt1
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Named ranges dissapear from list 4
How do I set up a Dynamic Named Ranges in Excel 2007 7
Drop Down with dynamic named range offsheet source list 14
Named Range maker code 9
VBA - retrieve data on last create named range from previous inserted named range 0
How to make a dynamic named range 4
Dependent drop down dynamic range formula, off sheet. 7
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0

Top