Question

How do i get the old value of a changed cell in excel?

Answer 1

Private Sub Worksheet_Change(ByVal Target As Range) Dim cell As Range Dim old_value As String Dim new_value As String For Each cell In Target If Not (Intersect(cell, Range("cell_of_interest")) Is Nothing) Then new_value = cell.Value old_value = ' what here? Call DoFoo (old_value, new_value) End If Next cell

Answer 2

u cna get the old value of a changed cell in excel by..

again writing the value only...

there is no another way if u didn't save your data..