Is it possible to print JUST the odd numbered pages from multiple tabs?

Wulf

Active Member
Joined
Dec 1, 2004
Messages
315
Is it possible to print JUST the odd numbered pages from multiple tabs?
I have a workbook with 32 tabs. 27 of them are Performance Enhancement Evaluations. Each of those 27 tabs has two pages if printed out (a front and back). Is it possible to print out JUST the front (the odd number <1>) from each tab in a single print job.

I can print everything out in a single print job by grouping the tabs, but I don't need the back.

Thanks.
 

RalphA

Well-known Member
Joined
May 14, 2003
Messages
3,829
I have seen a selection choice of "Print odd pages only", "Print even pages onlky", but, I don't find such choices in my present printer. I am almost 100% sure that this choice is contained in the paticular printer's driver.
 

gauntletxg

Well-known Member
Joined
Jul 15, 2008
Messages
636
It sounds like you just want to print the first page of each worksheet, and not strictly the odd numbered pages, correct?

perhaps

Code:
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
    ws.PrintOut 1, 1
Next ws
 

Forum statistics

Threads
1,078,363
Messages
5,339,758
Members
399,321
Latest member
ladeko

Some videos you may like

This Week's Hot Topics

Top