Mike,

Try something like the following:

Application.Wait Time:=Now + TimeSerial(0, 0, 5)


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
www.cpearson.com



"Michael Loganov" wrote in message
...
Hi,

how can I pause a code execution for, let's say 5 seconds?

Thanks in advance
Mike