How to forbid querytable to insert new rows

  • Thread starter Thread starter Alexey Korobkin
  • Start date Start date
A

Alexey Korobkin

Hello, All!

I need to create many QueryTables, one below another.
But when I insert the second one (from macros), the first QueryTable shifts
to the right (because QueryTable inserts itself as a new column).

What could I do to avoid this kind of its behavoir?
 
One way is to use
activesheet.cells.delete
at the start

you may also want to delete the many names that will ensue from each query.
for each n in names
if left(n.name,3)="Ext" then n.delete
next
 
You must log in or register to reply here.

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

Question on Deleting Querytables 3
how delete old querytables? 2
QueryTable Supress Headers? 0
call multiple macros in workbook_open? 6
listobjects and querytables 0
Querytable Class Module 3
Reset QueryTable error on empty text file 0
Copy/Paste of QueryTable doesn't adjust relative parameters 1

Back
Top