Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to print only odd pages & then even pages
I need to print only odd pages & then even pages
so paper will be double sided |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
I need to print only odd pages & then even pages
Wink, some printers have an option to do this, if not here is some code by
Gord Dibben to do it Sub PrintDoubleSided() 'Will print odd or even pages 'By Gord Dibben Dim Totalpages As Long Dim pg As Long Dim oddoreven As Integer On Error GoTo enditt Totalpages = ExecuteExcel4Macro("Get.Document(50)") oddoreven = InputBox("Enter 1 for Odd, 2 for Even") For pg = oddoreven To Totalpages Step 2 ActiveWindow.SelectedSheets.PrintOut from:=pg, To:=pg Next pg enditt: End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Wink" wrote in message ... I need to print only odd pages & then even pages so paper will be double sided |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Should all pages in a workbook print in color? | Excel Discussion (Misc queries) | |||
Print pages in a different order | Excel Discussion (Misc queries) | |||
Print Odd/ Even or specified pages in excel at a time. | Excel Discussion (Misc queries) | |||
How can I print an organization chart across 15 pages correctly? | Excel Discussion (Misc queries) | |||
print different row titles in one sheet w/ many pages | Excel Worksheet Functions |