set a code to run on a timer

[losmi8]

Hi guys. Below is a code that is triggered by an event, worksheet change. How would I slow this code down, to work every 60 seconds?

On Sheet1, Range A2 to I2, I have some data that changes a few times a second, and my code copies that data on the Sheet2 after it adds a row (so I can build a database of all data that comes in).


Now, there is way too much data coming in, so how can I only copy-paste the values (as I am doing right now) by at set intervals? For instance, every 60 seconds I would want my code to run?

Please Login or Register  to view this content.

[Simon Lloyd]

Check out Chip Pearsons reply here http://www.thecodecage.com/forumz/ex...time-code.html