Archive of Mr Excel Message Board
Back to Printing in Excel archive index
Back to archive home
Multiple print ranges
Posted by John on October 31, 2000 2:00 PM
Is it possible to have multiple print ranges set in one document? I have one huge spreadsheet, however I have to print different information from this report to different people. Currently I have to go to each portion and reset the print range. Any help would be appreciated!
Re: Multiple print ranges
Posted by Ivan Moala on November 01, 2000 12:04 AM
As a quick work around you could define your print
ranges eg. Select the areas to print by highlighting
Then in the names Box avail. in the Formula bar
type in the name, repeat until you have the names
and the reference ranges.
Eg you may have Peter_Rpt,Mine,Msoft etc.
When you want to print them just click in the drop
down name box and select the name. This will highlight
the area. Now select File / Print in the dialog
box [Print what] select SELECTION.
Note: don't use the print icon to do this.
HTH
Ivan
Re: Multiple print ranges
Posted by John Bingham on November 02, 2000 12:31 PM
There is a free report manager add-in for this. enter "report manager" in your help search.
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.