I have a number of workbooks, with between 30 to 70 worksheets, all with web
queries. Some of the worksheets will download some text into cell A10 that I
don't want.

I could go to each workbook to clear the contents of that cell, but I'm
looking for an automated process if possible.

TIA,

Bob

You would probably need a macro to do it. but why do you have so many web
queries? I suspect that you could have a looping macro to do this more
efficiently.

--
Don Guillett
SalesAid Software

"Bob Smith" wrote in message
nk.net...
I have a number of workbooks, with between 30 to 70 worksheets, all with
web queries. Some of the worksheets will download some text into cell A10
that I don't want.

I could go to each workbook to clear the contents of that cell, but I'm
looking for an automated process if possible.

TIA,

Bob

One other option, if you just don't want to see that text, would be to use
Conditional Format in cell A10 of those particular sheets:
Cell Value is | Greater than | 0
that's a zero for the greater than value.

And set the font color to the same color as the cell shading/background.
The text will still be there, just not visible. How practical this
suggestion is depends on whether or not you feel like setting up the
conditional formatting on what is potentially a large number of worksheets.
Although there's a lot of manual work to do up front, it's 100% automated
after that is done.

The other solution is to create a macro that picks the specific sheets and
clears the entries in cell A10 on-demand. You can make that by simply
recording the process once in each book, thus creating a 'custom' macro in
each book, and then you can call the macro from Tools | Macro | Macros when
ever you need to clear them.

If you're doing the web queries from a macro, you could cut the code from
the recorded macro and paste it in at the end of the macro doing the web
query so that after the data has been retrieved, cells A10 on the offending
sheets is cleared out.

"Bob Smith" wrote:

I have a number of workbooks, with between 30 to 70 worksheets, all with web
queries. Some of the worksheets will download some text into cell A10 that I
don't want.

I could go to each workbook to clear the contents of that cell, but I'm
looking for an automated process if possible.

TIA,

Bob