Have you looked at either the Worksheet_Change event or the
Worksheet_Calculate event?

--

HTH

RP
(remove nothere from the email address if mailing direct)


"ALVESM" wrote in message
...
hey how's everything? i've got a spreadsheet that is linked to reuters
Xtra3000 and gets updated every 10s. my goal is to copy the value from a
specific cell and paste it on some other cell. then after 10s repeat it,
copying the same cell, but pasting it on a different one so i can come up
with a series of values.
afterwards i'd like to plot a chart based on the copied range of cells
that
gets updated as we go.
can someone point out what should i be doing?
thanks in adv,
Miguel