| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Set Multiple Print Areas
Hi,
I have numerous sheets in my workbook and I have to print each one of them. Is there a way where I can automatically (VB?) set the print area for each one, as they are of different sizes. Thanks! |
|
#2
|
|||
|
|||
|
The easy way would be to mark each area and Insert - Name - Define for that area. Then to print, select the name from the dropdown, and Print - Selection. This does not allow you to have different Header rows though -- Bryan Hessey ------------------------------------------------------------------------ Bryan Hessey's Profile: http://www.excelforum.com/member.php...o&userid=21059 View this thread: http://www.excelforum.com/showthread...hreadid=381095 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Print all charts in a workbook (multiple worksheets) | Charts and Charting in Excel | |||
| Print ascending number on multiple printed cpoies | Excel Discussion (Misc queries) | |||
| What is the simplest way to print multiple worksheets? | Charts and Charting in Excel | |||
| set the print area print multiple tabs | Excel Discussion (Misc queries) | |||
| Multiple Worksheets and Print Merge function | Excel Discussion (Misc queries) | |||
Linear Mode
