I have multiple quireies in column A on one worksheet and apparently
the cell reference where I stored the web query keeps changing. When I
run the macro by selecting that cell it is not running because the cell
has moved.

Is there any way to have a code that runs ALL web quireies on a
worksheet?

Thnax

ActiveWorkbook.RefreshAll

It is a workbook property, not a worksheet.
Mike F
"J.W. Aldridge" wrote in message
oups.com...
I have multiple quireies in column A on one worksheet and apparently
the cell reference where I stored the web query keeps changing. When I
run the macro by selecting that cell it is not running because the cell
has moved.

Is there any way to have a code that runs ALL web quireies on a
worksheet?

Thnax

What would be the entire code to run this when the workbooks is opened?


Thanx.

Maybe if i elaborate, someone will be able to help a little further....

My problem is: I have a workbook that contains a spreadsheet were i
keep all of my web inquireis on. I have about 6 quiries on one page.
(A2, A3000,A10000,A22000,A36000,A50000). I recorded a macro to run each
query in its specific block however, the blocks tend to move from its
original location.

I would like to run all of them simultaneously when i open the workbook
(in hopes that the location of the specific cells wont change
completely out of range. I wont be saving the sheet, just runnning it
an printing the info).

Thanx.

Do you want to print individually or all together?
a macro can either get oneprint itget another etc
or
find the next plact to put the query and then print all together

--
Don Guillett
SalesAid Software

"J.W. Aldridge" wrote in message
ups.com...
Maybe if i elaborate, someone will be able to help a little further....

My problem is: I have a workbook that contains a spreadsheet were i
keep all of my web inquireis on. I have about 6 quiries on one page.
(A2, A3000,A10000,A22000,A36000,A50000). I recorded a macro to run each
query in its specific block however, the blocks tend to move from its
original location.

I would like to run all of them simultaneously when i open the workbook
(in hopes that the location of the specific cells wont change
completely out of range. I wont be saving the sheet, just runnning it
an printing the info).

Thanx.