Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Sub SetPageBreaks(SheetObj As Worksheet)
- Dim TotRow%, LinesPerPg%, NumPgs%, Page%
- TotRow = SheetObj.UsedRange.Rows.Count
- LinesPerPg = 56
- NumPgs = RoundUp(TotRow / LinesPerPg)
- With SheetObj
- .ResetAllPageBreaks
- For Page = 1 To NumPgs
- .Rows(LinesPerPg * Page + 1).PageBreak = xlPageBreakManual
- Next Page
- .Columns("J").PageBreak = xlPageBreakManual
- .Columns("H").PageBreak = xlPageBreakNone
- End With
- End Sub
- Function RoundUp(ByVal Number As Double) As Long
- RoundUp = Application.WorksheetFunction.RoundUp(Number, 0)
- End Function
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement