Cell Memory/Delay

[Mohsen25]

How to memorise/store the previous value of a calculation, for a comparison use with the current value.
Example: a calculation output the result value in cell A1. When A1 result changes, the previous result to be shown in cell A2.

 

[MikeVol]

Hi @Mohsen25.
I'm not sure I understood you correctly. But try the following code. Enter it into the sheet module where the result in A1 (because it contains a formula) is changed.

Option Explicit
Dim lastValue       As Variant

Private Sub Worksheet_Calculate()
    Dim currValue As Variant
    currValue = Me.Range("A1").Value

    If currValue <> lastValue Then
        Me.Range("A2").Value = lastValue
        lastValue = currValue
    End If

End Sub

I hope I understood you correctly and my solution helped you solve your question. Good luck.