Data Connection: Problem: Importing Header from Data Source...
Okay... I'm selecting a data range which I've already named in the source workbook, upon importing the data into the cell I choose the data comes in as a table with headers.
The problem is two-fold:
1. I only need the range of data to import (NOT AS A TABLE)
2. upon importing, it comes in as a table that I have to manually go in and convert to a range.
Is there a method to avoiding this or is this just one of those things that you have to manually do?
Re: Data Connection: Problem: Importing Header from Data Source...
post the code you currently have and show the result you get and your desired result