Using a dde link how do I write the data from the "live" cell to a
static cell so I may have a reference of the data at a certain time of
day. I have been given a macro (from this group) that will fire at a
certain time. However the recording from the dde linked cell to the
non dde linked cell is beyond me. Thanks
CBarnes

to copy from one cell to another is trivial, just add a line to your existing
code

eg

Worksheets("target").range("A1").Value =
Worksheets("source").range("A1").Value

change the sheet names and cell references accordingly/appropriately





"chuckb74" wrote:

Using a dde link how do I write the data from the "live" cell to a
static cell so I may have a reference of the data at a certain time of
day. I have been given a macro (from this group) that will fire at a
certain time. However the recording from the dde linked cell to the
non dde linked cell is beyond me. Thanks
CBarnes