http://www.mcgimpsey.com/excel/sequentialnums.html


--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Paul (Not a Programmer)" <Paul (Not a
wrote in message
...
I'm not a programmer and I'm trying to learn how to write some VB code in
Excel.

Anybody have something written to generate a numbering system, and then
use
the next available number to assign to a quote, and keep track of each
used?