Assigning unique serial number

B

byudantheman

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?
 
G

Gord Dibben

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
 
Top