is it possible to print multiple pages with different numbers

  • Thread starter Thread starter des-sa
  • Start date Start date
D

des-sa

please help.
how do i print multiple copies of the same worksheet, but numbered
consecutively.
 
They could to be printed with a macro that prints one sheet, changes the "First page number"
in File - Page setup, prints again, etc. Or you could duplicate the sheets, then print the
workbook (or those selected sheets), leaving "First page number" set to Auto.
 
This macro was just what I was looking for. We are trying to print a log
book, which consists of just one page and wanted it numbered page1, page2,
page3, etc. I used the macro option to print the number in the footer.
However, our user wants to use our duplex print, so that page 2 will print on
the back of page 1, page 4 will print on the backup of page 3 etc. We have
duplex enabled in our printer driver and is set at default in our printer
properties. When I run the macro, the printer does feed it through again, to
print on the other side, but it comes out blank. So, we are getting page 1,
then a new page for page 2, new page for page 3 etc.
This seems so close to what we are looking for. Ist there a statement that
can be added to the macro to print on the duplexed side ?

Thanks, Anne
 
Hi Anne

I never have a duplex printer so I not know
Maybe others can test it for you.

Sorry
 
Back
Top