How to forbid querytable to insert new rows

  • Thread starter Alexey Korobkin
  • 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?
 
D

Don Guillett

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
 
Top