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
--
HTH...

Jim Thomlinson


"BarryS" wrote:

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.