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
 
Back
Top