Store peak cell value

[nandina]

Hi there

I am not too familiar with excel - but am trying to retain the highest value of a single excel cell, which is coming into the spreadsheet from an external data source.

IF clause and MAX formula give errors as they cause a circular reference. How would you store the highest input value when referenced against itself as the new value comes in ? ie. a type of peak value recorder on a single cell value which is updated every 15 minutes.

Thanks in anticipation.

 

[ETID]

copy this into the sheeet change event in the vba editor...

change a2 to the cell the is linked to external data and d2 to a target cell of your choice.


Private Sub Worksheet_Change(ByVal Target As Range)
If Range("a2&quot > Range("d2&quot Then
Range("d2&quot = Range("a2&quot
Else
End If
End Sub