You might try application.wait:-

Application.Wait Now + TimeValue("00:00:10")

will cause a 10 second pause.

Mike

" wrote:

Does anyone know how to introduce a time delay into VBA macros? I created a
macro that runs an application on about 15 different worksheets. I want to
be able to have the macro pause between worksheets, to allow this application
to have enough time to download on every sheet. Is this possible? If so,
what code would I need?

Thanks

Adam Bush