Hi there,

Im looking for a way to pause lets say 10 seconds between two macro's
I used timerinterval as a function and inserted "Run code inbetween two macros but nothing happened." this is the function which I am calling.

Function pause()
TimerInterval = 20000
End Function

anyhelp is welcome....

Hi Paul,

While pausing, do you want any other code to run? Why is the pause necessary?
Just want to understand a bit more about your problem.

Rob

The pause is needed because another database is should run first and when this is completed the 2nd macro can start..