Dim oQT as Querytable
set oQT = Activesheet.QueryTables("MyQuery")

MyQuery being the name of the Querytable (modifiable in Properties)

works by me.

HTH
--
AP

a écrit dans le message de news:
...
Is there a way to refer to Query Tables by name instead of by index
number? Or is there a way to change the index numbers? I have a sheet
with a large number of querys and need to reference them individually,
preferably by name.