Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Reset QueryTable error on empty text file | Excel Programming | |||
Macro inserts a column but dont update formulas in another sheet! | Excel Programming | |||
Macro which inserts a column and cut and pastes data | Excel Programming | |||
Macro which inserts a column and cut and pastes data | Excel Programming | |||
ADO inserts text strings not numbers when table is empty | Excel Programming |