View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Smith Bob Smith is offline
external usenet poster
 
Posts: 28
Default Is there a formula to clear the contents of a specific cell?

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