QueryTable inserts empty column?

M

Maury Markowitz

I have a table with a lookup key in column 1, and a variety of data in other columns. One of these is empty, and I'm trying to populate it with data from a local DB.

I'm making up some SQL, using QueryTables.add, and returning the results into a cell in the empty column. All of this works fine - the data is being returned correctly.

However, it is also inserting a new blank column into the sheet. I have line numbers and column headers turned off, and there's nothing in the new column.

Any ideas?
 

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

Dealing with the error: unable to filter on excel hc home school 0
AppleScript - How do I select a text ? 1
Cumulative formula for word table 0
Shared Link is showing empty notebook 1
Two columns followed by single page-width column on same page 0
A data validation question 1
List all tables, including document structure 0
Check for values in column A and if found then column B must have value. 3

Top