Auto Clear Cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have been given the task of creating a simple office sheet that would serve as an In/Out Board. We want to have certain cells be cleared everyday so that the comment areas are fresh to add notes to. How specifically can I add a macro that will automaticall clear a set of cells at a certain time? The cells can only be cleared once a day and not every time the file opens

Please help

Pete
 
Pete,

An example :

Sub ClearCells()
Worksheets("Sheet1").Range("D2").ClearContents
Worksheets("Sheet1").Range("H4:J6").ClearContents
End Sub

Replace the sheetnames en the cellranges to the values you need and run the
macro whenever you need it to run.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

PeteS said:
I have been given the task of creating a simple office sheet that would
Click to expand...
serve as an In/Out Board. We want to have certain cells be cleared everyday
so that the comment areas are fresh to add notes to. How specifically can I
add a macro that will automaticall clear a set of cells at a certain time?
The cells can only be cleared once a day and not every time the file opens.
 
Back
Top