excel

[BarryS]

Is there a VBA code were i can print one worksheet multiple times and have a
file no. print in sequential order each time i print the worksheet.
ie. print 10 copies of the worksheet and the file no. will be 000001 -
000010. And the next time I print 10 copies the file no. will be 000011 -
000020.

 

[Jim Thomlinson]

Yes but there are some decisions to be made in terms of how to impliment the
sequential numbers. Check out this link...

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

 

[Gord Dibben]

See Ron de Bruin's site for this.

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

Note the second set of code that allows for starting from where you left off.


Gord Dibben MS Excel MVP