Problems using Worksheet_Change
Does someone knows if exist any way of getting the old value in this:
Private Sub Worksheet_Change(ByVal Target As Range)
€˜ for the new data coming is easy:
New_data = Target.Value
€˜And about the old data into the cell€¦. Is there something like:
Old_data = Target.Old_data
End Sub
Thanks a lot
Peres
|