LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10,124
Default Is there a formula to clear the contents of a specific cell?

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



 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
A challenge: referencing cell contents in nested function formula Needs Assistance Excel Worksheet Functions 3 October 28th 06 02:17 AM
Custom functions calculating time arguments Help Desperate Bill_De Excel Worksheet Functions 12 April 25th 06 02:22 AM
How do I clear the contents of one cell from another cell? RonB Excel Worksheet Functions 1 September 26th 05 07:33 PM
Formula checking multiple worksheets sonic-the-mouse Excel Worksheet Functions 2 June 5th 05 07:48 PM
Formula to return cell contents based on multiple conditions Bill Excel Worksheet Functions 3 January 19th 05 09:59 AM


All times are GMT +1. The time now is 12:25 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"