Hi All

trying to implement data validation where the number entered must be 1
greater than the maximum value in a dynamically defined range.

e.g. mylist is defined as =OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)
and i want to say that the value must be a whole number equal to
=MAX(mylist)+1

Cheers
JulieD

Hi Guys

solved it ...

Cheers
JulieD

"JulieD" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi All
>
> trying to implement data validation where the number entered must be 1
> greater than the maximum value in a dynamically defined range.
>
> e.g. mylist is defined as =OFFSET(Sheet1!$A$1,0,0,Counta(Sheet1!$A:$A),1)
> and i want to say that the value must be a whole number equal to
> =MAX(mylist)+1
>
> Cheers
> JulieD
>
>