Horizontal Page Breaks

  • Thread starter Thread starter Sam
  • Start date Start date
S

Sam

HI:

Can anyone tell me if there is a limit to the number of
horizontal page breaks I can have in a work sheet.
I have a sheet with 43 Pages, which ends at Row 2066.
When I add another page, I am unable to pull the print
area down any further.
If I go up a few rows and insert a page break, I can
adjust that just fine. However, I can still not pull it
past row 2066.

Thanks,

Sam
 
I ran this macro:

Option Explicit
Sub testme01()

Dim iCtr As Long
ActiveSheet.ResetAllPageBreaks
For iCtr = 2 To 65536 Step 2
ActiveSheet.HPageBreaks.Add before:=Cells(iCtr, "A")
Next iCtr

End Sub

And got an error message that said that I can't have more than 1026 horizontal
pagebreaks per worksheet.

And just playing around, I could pull the print range down at row 2210.

As a workaround, could you use File|Print Area?

(I used xl2002 for my testing.)
 
Back
Top