Pete

To go with Auk's code you can visit Chip Pearson's site and learn how to run
the code at a specific time.

http://www.cpearson.com/excel/ontime.htm

Gord Dibben Excel MVP

On Tue, 10 Feb 2004 23:33:07 +0100, "A.W.J. Ales"
wrote:

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.