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

"BMT" wrote:

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