I would like to run a macro at 3.45pm everyday. How would I do it? TIA Tam
J Jason Morin Mar 2, 2005 #2 Use the OnTime method. For examples, see VBA Help as well as Chip Pearson's site: http://www.cpearson.com/excel/ontime.htm HTH Jason Atlanta, GA
Use the OnTime method. For examples, see VBA Help as well as Chip Pearson's site: http://www.cpearson.com/excel/ontime.htm HTH Jason Atlanta, GA
T Tam Mar 2, 2005 #3 It doesn't say how to run it at a certain time. I would like to run this macro at 3.45pm Thanks Tam
J Jason Morin Mar 2, 2005 #4 Um, did you read on-line help or go to Chip's website? The instructions are pretty clear. Jason