Prev: what is the formula for what I want to do
Next: Check column header value
From: Sach1810 on 5 Mar 2010 04:58
On 5 Mar, 08:25, dk <mcdivyaka...(a)gmail.com> wrote:
> On Mar 5, 1:01 pm, Sacha David <sach1...(a)googlemail.com> 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
First  |  Prev  | 
Pages: 1 2
Prev: what is the formula for what I want to do
Next: Check column header value