On Apr 30, 12:10*pm, wrote:
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

I forgot to mention that B1 changes for each stock - say B15, B25, B35
etc