See

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


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"stacey" wrote in message
...
i want to create an invoice that opens with a unique number following on
from
previous. similiar to the database facility that creates an autonumber for
each new record.