how do i set up excel to print multiple copies of the same sheet but have consecutive page numbes?
B BMT Jan 23, 2006 #1 how do i set up excel to print multiple copies of the same sheet but have consecutive page numbes?
N Nick B Jan 23, 2006 #2 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
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
