Another timed macro question
Posted by Darci on May 21, 2001 1:48 PM
i have another question as a follow up to #17867
i am trying to have a macro start at 10am, and it hasn't worked thus far. I cannot get the code to run the macro. I haven't gotten any error messages, but it doesn't do anything. Here is the code i am using...
(in the general module)
Sub StartTimer() Sub Macro1() ' ' Macro1 Macro ' 10am price cut&paste values ' ' Application.Run "RefireBLP" Range("T4:T17").Select Selection.Copy Range("U4:U17").Select Selection.PasteSpecial Paste:=xlValues, Operation:=xlNone, SkipBlanks:= _ False, Transpose:=False Application.CutCopyMode = False ActiveWorkbook.Save Range("X8").Select Application.OnTime TimeValue("09:58:00"), "StartTimer" i need the values at 10am, does the 5min interval in you 11.55 and 12.00 example matter.?? please let me know.. thanks again for all of your help