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.

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

--
Message posted via http://www.officekb.com

Thanks for your input Oliver.