Perhaps a better way to do this would be to have ONE query with a looping
macro using a variable and exporting the data to another area for use as
desired.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

wrote in message
...
My sheet has a number of queries that look at the web to return tables
of share prices. I use this statement


Worksheets("Data").Range(B1).QueryTable.Refresh

for each stock.

I would like to run all the queries at once rather than looping
through each one - in an effort to speed it up.
Can it be sped up? What might the code look like?

Thanks

Gavin