Re: vba code for excel file
there is a recent thread that does several of these things see if it helps at all
http://www.vbforums.com/showthread.p...s-over-a-range
Re: vba code for excel file
Hi westconn1, I've had a look at the thread you suggested and amended my code according to it. However, it doesn't seem to update the information for the time I set it to be. Would you mind helping me to check my code? Hope to hear from you soon.
Code:
Sub copypaste_RECENT()
Sheets("t").Range("B:V").Copy Destination:=Sheets("y").Range("B:V")
Application.OnTime Now + TimeSerial(12, 45, 0), "copypaste_RECENT"
End Sub
Re: vba code for excel file
is this procedure in a std module or an object module
Re: vba code for excel file
Hi westconn1, the procedure is in standard module.
Re: vba code for excel file
is every 12¾ hours the correct schedule? or should it be something different?
if it is 12:45 pm, then it should not be adding the time to now
Re: vba code for excel file
Hi westconn1, it's 12.45pm. Do you meant I should use Date instead of Now?