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