Delay between running macros
Posted by jgm on December 07, 2000 7:24 PM
Is there a way in Excel to run a macro, wait 10 seconds and automatically run another macro.
Posted by Celia on December 07, 2000 9:13 PM
jgm
Add this line at the end of your macro :-
Application.Wait Now() + TimeSerial(0,0,10)
and then a line that calls your other macro
Celia
