Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
Print multiple ranges on one sheet?
Posted by Frank H. on March 09, 2001 6:03 AM
Can someone help me create a macro to print two different ranges (each on a different tab of the workbook) on one page?
Re: Print multiple ranges on one sheet?
Posted by Roger Redhat on March 10, 2001 1:16 AM
One method would be with the use of the Union function which returns a single range object of multiple ranges. However, the function cannot join ranges from separate sheets (the ranges must all be on the same tab). You could however get around this by temporarily copying your data all to the same sheet, using the union function to return a single range, setting the print area and then using the PrintOut method.
Alternatively, why not just copy all of the relevant data to a temporary sheet and print that out?
This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our
online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.