Excel Macros that run at specific time

[Barry]

Does anyone know of how to write a macro which does a simple copy from
one cell and past as values to another sheet at at 5pm every day?

Many Thanks
Baz

 

[Chip Pearson]

Barry,

You can use the OnTime method to execute a method at a specific time. See
www.cpearson.com/excel/ontime.htm for details.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com [email protected]