consecutive page numbers of the same page
 

how do i set up excel to print multiple copies of the same sheet but have
consecutive page numbes?

consecutive page numbers of the same page
 

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

"BMT" wrote:

how do i set up excel to print multiple copies of the same sheet but have
consecutive page numbes?