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