Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
That didn't seem to make any difference, still prints to 24 pages.
A:H prints Page 1 (although could be to Col I, as I don't have grid lines shown and Col I is blank) I:R prints Page 2 (which is 10 columns) Code as below Sub Print_Per() Dim i As Integer Application.ScreenUpdating = False With Sheets("Month") With .PageSetup .PrintArea = "$A$66:$GU$99" .Orientation = xlLandscape .Draft = False .PaperSize = xlPaperA4 .FirstPageNumber = xlAutomatic .Order = xlDownThenOver End With .ResetAllPageBreaks .HPageBreaks.Add .Range("I100") For i = 1 To 29 .VPageBreaks.Add .Cells(1, i * 8) Next .PrintOut Copies:=1 End With Application.Goto Sheets("Header").Range("A1") End sub |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
I can't move my page breaks in Page Break Preview | Excel Discussion (Misc queries) | |||
Page Preview showing placement of page breaks | About this forum | |||
Vertical page breaks won't drag in Page Break Preview | Excel Discussion (Misc queries) | |||
How do I do page breaks when view menu doesnt page break preview | Excel Discussion (Misc queries) | |||
Page Breaks- Printing selected rows on same page | Excel Discussion (Misc queries) |