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

  • Thread starter Thread starter chuckb74
  • Start date Start date
C

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
 
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
 
Back
Top