How do I set up an Excel template to generate a new number every .
 

Then you have to store the last number somewhere.

Look at savesetting and getsetting to store it in the registry.

Of course this would assume the template is only used on one computer.

--
Regards,
Tom Ogilvy

"ari" wrote in message
...
I want Excel to generate a new number, in ascending order, and print it in
a
certain cell, every time I open the template.