On 5 Mar, 08:25, dk wrote:
On Mar 5, 1:01*pm, Sacha David wrote:

Hi, *I Have a cell say a1 that has a continuously changing number it
in and I want to track the highest number that it prints, *and the
same for the lowest number in cell a2. I would like these results to
show up in the cells below them

Im very new to programming and your help would be much appreciated

many thanks

Sacha David

One way is to write a macro:

Dim prvValue as integer

Sub Get_Max()

Application.Volatile

if prvValue<range("A1").value
prvValue = range("A1").value
end if
range("A2").value = prvValue

End Sub

ok I have got this to work but it does not run continually, so it is
constantly keeping track. Any ideas

Thanks again

Sacha