One way:
'The low number is shown in B1, the high in C1. The changing cell is A1.
'Put 1000000 in B1 and "0" in C1 to begin
Private Sub Worksheet_Change(ByVal Target As Range)
If IsEmpty(Target) Then Exit Sub
If Target.Address(0, 0) = "A1" Then
If Target.Value < [B1].Value Then [B1].Value = Target.Value
If Target.Value [C1] Then [C1].Value = Target.Value
End If
End Sub
HTH Otto
"Stock Help" <Stock wrote in message
...
I would like to know how to show the high value and low value of a cell
that
is showing the trade by trade of a stock.