How to let the looping wait
 

Hello,all. Can someone help me with this problem:

I am trying to value paste some dynamic data as the NOW Function
changes, but the thing is in the looping I would like to value paste
just every 5 seconds. How to make this realised, that means make the
looping wait, without exausting the computer.

What I have done is let it loop as long as Now is bigger than one num,
then choosing to excute the value paste every 5 seconds. But the
computer goes dead.

thanks a lot.

How to let the looping wait
 

It might be better to figure out why your code isn't working for manual
entry. I suspect you may be using a worksheet change event. I know I have
this problem when I put

Application.EnableEvents = FALSE

at the beginning of the code and then forget to reset it at the end with

Application.EnableEvents = TRUE

If this isn't the issue, post your code and someone should be able to assist.

HTH,
Barb Reinhardt

"jonathan" wrote:

Hello,all. Can someone help me with this problem:

I am trying to value paste some dynamic data as the NOW Function
changes, but the thing is in the looping I would like to value paste
just every 5 seconds. How to make this realised, that means make the
looping wait, without exausting the computer.

What I have done is let it loop as long as Now is bigger than one num,
then choosing to excute the value paste every 5 seconds. But the
computer goes dead.

thanks a lot.