How can I make Excel copy and paste specific cells every 15minuts
 

Can you please help me to make a function in Excel to copy a specific group
of cells (updated by DDE) and paste them every 15 minutes in a new line

How can I make Excel copy and paste specific cells every 15minuts
 

Take a look at Application.OnTtime function

Application.OnTime Now + TimeValue("00:15:00"), "CopyLine"

Procedure CopyLine would be executed in 15 minutes time, put above in a
controlled loop to repeat.


--

Regards,
Nigel




"Vico" wrote in message
...
Can you please help me to make a function in Excel to copy a specific
group
of cells (updated by DDE) and paste them every 15 minutes in a new line