Greg,

Try

Application.Wait Now + TimeSerial(0, 0, 5)



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

"Greg" wrote in message
...
Hi all,

How do I get a macro to pause for 5 seconds and then continue
with the rest of the code?

Thanks

Greg