Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply a print area to an entire workbook
I want to apply a print range to multiple worksheets in the same workbook.
The data area in all the worksheets is the same & I'd like to know if there is an easier way of applying rather than having to go into each worksheet. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do you apply a print area to an entire workbook
You can use a macro like this to apply the same print area to all worksheets:
Sub printarea() For Each ws In Worksheets ws.PageSetup.printarea = "$A$1:$D$5" Next ws End Sub To apply to a group you could use something like: Sub printarea() ws = 0 While ws < 2 ws = ws + 1 ActiveWorkbook.Sheets(ws).PageSetup.printarea = "$A$1:$b$3" Wend End Sub (This would only affect sheets 1 and 2) Andrea Jones www.stratatraining.co.uk "Darrelldebb" wrote: I want to apply a print range to multiple worksheets in the same workbook. The data area in all the worksheets is the same & I'd like to know if there is an easier way of applying rather than having to go into each worksheet. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Setting print area for entire workbook | Excel Discussion (Misc queries) | |||
How can I apply print area and page setup to entire workbook? | Excel Discussion (Misc queries) | |||
Set print area for entire workbook | Excel Discussion (Misc queries) | |||
how to set print area for the entire excel workbook | Excel Discussion (Misc queries) | |||
changing print area in an entire workbook | Excel Worksheet Functions |