Hi
I have a cell with a DDE link from another program, which is sample data I
need to record.
To do this I need to copy the value of the cell, A1, and paste it into B1,
when the cell value changes I need to copy the new value from A1 into B2 and
so on. I can then produce a real time graph from the information in column B.

Any Ideas
Thanks
Alec