copy & paste the code:
Sub Odd_Even_Print_Reverse()
Dim StartPage As Long
Dim EndPage As Long
Dim Page As Integer
EndPage = InputBox("Enter the last page number")
StartPage = 1
For Page = EndPage To StartPage Step -2
ActiveSheet.PrintOut from:=Page, To:=Page, _
Copies:=1, Collate:=True
Next
End Sub
No comments:
Post a Comment