Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Print 2 pages per sheet
Hi
I have created a file that will print reports onto A4 pages, sometimes up to 30 pages will be printed at a time. I would like the option sometimes of being able to print 2 pages per sheet. I would like to do this through a macro and not manually through the current printer's option/setup dialog box. Previously, a workaround I have tried is to setup a specially formatted landscape page, copy two reports to that page and then print it. Updated shape positions on the original page though don't seem to transfer when copied. Is there a simple way through Excel VBA to print 2 pages per sheet ? TIA Andrew Bourke |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How print pages without including the first sheet? | New Users to Excel | |||
How to print multiple pages per sheet | Excel Discussion (Misc queries) | |||
Print multiple pages on one sheet | Excel Discussion (Misc queries) | |||
Print Chart in New Sheet on Two Pages | Charts and Charting in Excel | |||
print different row titles in one sheet w/ many pages | Excel Worksheet Functions |