Hi Nigel

J E McGimpsey has some suggestions on his site at
http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

--
Regards

Roger Govier


"Nigel 2000" wrote in message
...
What is the best way to generate an auto number, like an invoice
number, on a
template so that each time a new workbook is created a sequential
number
appears

thanks in advance