Using a dde link how do I write the data from the "live" cell to astatic cell
 

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

Using a dde link how do I write the data from the "live" cell to a
 

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