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

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
 
P

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top