consecutive page numbers of the same page

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

how do i set up excel to print multiple copies of the same sheet but have
consecutive page numbes?
 
Guess you could use code that keeps updating the footer with a number and
printing out the page.

Assuming only one page for each sheet, could use something like:
Sub PrintOut()
Dim i As Long
Const lngNumberofPrints As Long = 3

For i = 1 To lngNumberofPrints
ActiveSheet.PageSetup.CenterFooter = i
ActiveSheet.PrintOut copies:=1
Next
End Sub
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

is it possible to print multiple pages with different numbers 5
how to set page break for continuous numerical sheet printing 2
Continuous page numbering when printing whole book 2
Copying multiple cells out of multiple worksheets at same time. 1
Consecutive print numbers 3
Auto Number for Form 4
Printing dates 2
Automatic page numbering with multiple sheets in a workbook 2

Back
Top