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

--
__________________________________
HTH

Bob

"Big G" wrote in message
...
Hi,
I make Invoices in Excel and need a solution on following small problem:
When I open up a new Excel I want a cell called Invoicenumber to increment
1
to have a new Invoicenumber.
So if previous invoicenumber was 58 I want the new invoicenr to be 59.
I want this to happend automatic, i e it should be trigged by just opening
a
new Excel, but how?
Can somebody help me?
Gunnar S