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