If I understand what you're asking, does this work for you:

=MAX(A:A)+1

--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"CasaJay" wrote in message
...
This should be easy, but I'm stumped (relatively new user). I have a
column
of sequential numbers (except that the last numbers are 0) and I want to
select the next highest number in that range.