Hi,

All the methods are here

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

Mike

"Jo Ann P" wrote:

I am trying to set up invoicine where the number will change every time I
open it-to a next available number