ontime method?

[Guest]

I need to have the value in cell A1 copied to cell C1 at 700am each day. Can
Excel automate this process? Would the "ontime method" be the correct
approach for this problem? Thanks.

 

[Oliver Ferns via OfficeKB.com]

Yes. Application.OnTime would do this for you provided the file is open...

Sub Runmeat7()

Application.OnTime timevalue("07:00:00"), "MyMacro"

End Sub

Sub MyMacro()
me.range("C1").value = Me.Range.("a1").value
End Sub


Hth,
Oli

 

[max]

Thanks for your input Oliver.