automatic cell advancing
 

I am trying to come up with a macro that will take a dde link, copy it to a
cell and after 10 mintues, copy that same link to the next cell down a
column. The goal is to have a button that will start the macro and stop when
complete. Your help is greatly appreciated

automatic cell advancing
 

Look at Chip Pearson's page on using Application.Ontime

http://www.cpearson.com/excel/ontime.htm

--
Regards,
Tom Ogilvy

"Marc" wrote in message
...
I am trying to come up with a macro that will take a dde link, copy it to
a
cell and after 10 mintues, copy that same link to the next cell down a
column. The goal is to have a button that will start the macro and stop
when
complete. Your help is greatly appreciated