Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set print area for all worksheet except first two worksheets
I would like to set the print area for all worksheets except the first
two worksheets equal to the range (b5:r36,b38:b83). Any suggestions on how to do this? Thanks |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Set print area for all worksheet except first two worksheets
Sub test2()
Dim i As Long, sName As String For i = 3 To ActiveWorkbook.Worksheets.Count With Worksheets(i) sName = "'" & .Name & "'!Print_Area" .Names.Add sName, .Range("$B$5:$R$36,$B$38:$B$83") End With Next End Sub Regards, Peter T wrote in message ... I would like to set the print area for all worksheets except the first two worksheets equal to the range (b5:r36,b38:b83). Any suggestions on how to do this? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
copy print area to multiple worksheets | Excel Discussion (Misc queries) | |||
How can I set the print area for a worksheet equal to nothing? | Excel Discussion (Misc queries) | |||
Help with setting Print area to more than one worksheet with VBA | Excel Programming | |||
print a specific area within a worksheet by clicking on print? | Excel Worksheet Functions |