This pauses the macro for 120 seconds while other events are allowed to
occur.

t = Timer + 120
Do While Timer < t
DoEvents
Loop


"sdg8481" wrote in message
...
hi,

I want to be able to count from 1 to 120 seconds in a cell when i start
the
macro, and then stop when i get to 120 - what is the best way of doing
this.

Hope you can help.

Thaanks