Home |
Search |
Today's Posts |
#1
|
|||
|
|||
how do i record changing cell data (cell is dde linked)
I have a cell that is constantly changing value, and need to record these
changes so I can plot them on a chart. |
#2
|
|||
|
|||
How are they changing?
Is a user changing them by typing them in? You can do it using an event macro. Rightclick on the worksheet tab that should have this behavior. Select view code. Paste this into the code window. Then back to excel to test it out: Option Explicit Private Sub Worksheet_Change(ByVal Target As Range) Dim DestCell As Range With Target If .Cells.Count 1 Then Exit Sub If Intersect(.Cells, Me.Range("a1")) Is Nothing Then Exit Sub If IsEmpty(.Value) Then Exit Sub If IsError(.Value) Then Exit Sub With Worksheets("sheet2") Set DestCell = .Cells(.Rows.Count, "A").End(xlUp).Offset(1, 0) End With DestCell.Value = .Value End With End Sub I logged the value into sheet2 column A. Morph wrote: I have a cell that is constantly changing value, and need to record these changes so I can plot them on a chart. -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
mass cell data editing | Excel Worksheet Functions | |||
Printing data validation scenarios | Excel Worksheet Functions | |||
Changing Cell formats to date fields automatically | Excel Worksheet Functions | |||
inserting data from a row to a cell, when the row number is specified by a formula in a cell | New Users to Excel | |||
GET.CELL | Excel Worksheet Functions |