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?
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?
