Thanks I decided to try google and found the answer exactly what you wrote
Thanks to both of you for your answers

Greg
"Chip Pearson" wrote in message
...
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