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

[chuckb74]

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

 

[Patrick Molloy]

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