Clear Cell using R1C1 After xxxx # of seconds

[bemp87]

Hi Comunity,

I am using formula "Range("F6").FormulaR1C1 = "" " as part of a vba macro to clear values from a cell which is working perfectly. But i was curious if there is a way to delay the clearing to say maybe 15 seconds after the macro has ran?

Any guidance?

 

[Mike Blackman]

Hi,

You can use something like this:

Application.Wait(Now + #0:00:15#)