See Ron de Bruin's site for code to do exactly what you want when printing,
inclucing the "come back later and start from where you left off"

http://www.rondebruin.nl/print.htm#same

For simply assigning a new number each time you open the workbook see Jim's
posting.


Gord Dibben MS Excel MVP

On Tue, 8 Jan 2008 15:36:36 -0800, byudantheman
wrote:

Is there any way that you can assign a unique serial or form number with each
copy of something I print off? For example, if I have an invoice that I
print off 10 copies of, I want each copy to have a unique number in a cell.
Then the next time I open the program, I want it to continue counting. Any
ideas?