I'm trying to link to a named range within a spreadsheet. the range is a non-contiguous group of columns. However when I try to link to it the range doesn't show in the available range box. If I select a contiguous range that shows and I can select it. I also tried coding it using transfer spreadsheet but I got an error saying couldn't find the object 'Name of My range' Is this supposed to happen or am I missing something?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
link to named range
- Thread starter tizwaz
- Start date
PaulBricker
Programmer
Another way, not necessarily easier, would be to create another sheet in your workbook and reference the Columns that you want to import. Then name the sheet in your import routine.
Paul
Paul
- Status
Similar threads
- Locked
- Question
- Locked
- Question