ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   QueryTable inserts empty column? (https://www.excelbanter.com/excel-programming/448170-querytable-inserts-empty-column.html)

Maury Markowitz[_2_]

QueryTable inserts empty column?
 
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?


All times are GMT +1. The time now is 05:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com