application ontime use

[bkachra]

Hi, new to this board and have tried to use the advice already available but no sucess. I am guessing there is a simple solution.

I need to clear an area of 1 tab, cells A1: X10, at a particular day and time.
Does anyone know to do this? I understand its application.ontime I need to use?

Many thanks

 

[dantheman9]

Maybe;

Sub test
Dim cleartime As Date
 
cleartime = "00:12:00"
Application.OnTime cleartime, "cellclear",
End Sub
 
Sub cellclear()
 
' add the cells to clear here
 
End Sub

 

[bkachra]

Thank you for the prompt response, your solution doesnt state how to select a day and date, can you add to your response please?

Thanks