Hi all,

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

Thanks

Greg

I worked it out thanks anyway

Greg
"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

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

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

application.Wait now+timevalue("0:0:5")

HTH
--
AP

"Greg" a écrit dans le message de news:
...
Hi all,

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

Thanks

Greg