Hi,

I'm trying to write a macro that would copy a large
amount of data (20,000 rows of data) however I need to do
100 rows every 1 second. Therefore I need some sort of
function that will have a time delay of 1 second within
the macro. (copy 100 rows wait one second, copy 100 rows
wait one sec etc)

Does anyone know of a function that will create a time
delay within a macro?


thanks in advance