Thread: How can I make Excel copy and paste specific cells every 15minuts
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
  
Posts: 735
Default 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

Reply With QuoteReply With Quote