how can i extend the printable area up to the very last row

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)
--
HTH,
Barb Reinhardt



"kaveh" wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.


Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)

This blew up for me on the 1028th pagebreak:

Option Explicit
Sub testme()
Dim iCtr As Long

With ActiveSheet
On Error Resume Next
For iCtr = 2 To .Rows.Count
.HPageBreaks.Add befo=.Cells(iCtr, "A")
If Err.Number = 0 Then
'ok
Else
Err.Clear
MsgBox "Error with: " & iCtr & vbLf & iCtr - 1 & " worked ok"
Exit For
End If
Next iCtr
On Error GoTo 0
End With
End Sub




ps. I used xl2003.

Gord Dibben wrote:

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.

Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)

--

Dave Peterson

Blew up on me also.

My earlier test was manual by entering data in column A to row 65536.

Set margins to give me two rows per page.

Pagebreak preview shows 32768 pages.

This returns 32768 pages.

Sub test_pages()
totalpages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
MsgBox totalpages
End Sub

I'm not about to print out to testg


Gord

On Sun, 10 Aug 2008 20:26:27 -0500, Dave Peterson
wrote:

This blew up for me on the 1028th pagebreak:

Option Explicit
Sub testme()
Dim iCtr As Long

With ActiveSheet
On Error Resume Next
For iCtr = 2 To .Rows.Count
.HPageBreaks.Add befo=.Cells(iCtr, "A")
If Err.Number = 0 Then
'ok
Else
Err.Clear
MsgBox "Error with: " & iCtr & vbLf & iCtr - 1 & " worked ok"
Exit For
End If
Next iCtr
On Error GoTo 0
End With
End Sub




ps. I used xl2003.

Gord Dibben wrote:

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.

Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)

Although.......help on specs states 1000 horizontal and vertical pagebreak
limit

So..........what preview shows ain't necessarily what you will get.

Off to bed nowg


Gord

On Sun, 10 Aug 2008 20:36:41 -0700, Gord Dibben gorddibbATshawDOTca wrote:

Blew up on me also.

My earlier test was manual by entering data in column A to row 65536.

Set margins to give me two rows per page.

Pagebreak preview shows 32768 pages.

This returns 32768 pages.

Sub test_pages()
totalpages = Application.ExecuteExcel4Macro("GET.DOCUMENT(50)")
MsgBox totalpages
End Sub

I'm not about to print out to testg


Gord

On Sun, 10 Aug 2008 20:26:27 -0500, Dave Peterson
wrote:

This blew up for me on the 1028th pagebreak:

Option Explicit
Sub testme()
Dim iCtr As Long

With ActiveSheet
On Error Resume Next
For iCtr = 2 To .Rows.Count
.HPageBreaks.Add befo=.Cells(iCtr, "A")
If Err.Number = 0 Then
'ok
Else
Err.Clear
MsgBox "Error with: " & iCtr & vbLf & iCtr - 1 & " worked ok"
Exit For
End If
Next iCtr
On Error GoTo 0
End With
End Sub




ps. I used xl2003.

Gord Dibben wrote:

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.

Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)

Thnks for your answear

"Barb Reinhardt" wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)
--
HTH,
Barb Reinhardt



"kaveh" wrote:

how can i extend the printable area up to the very last row (i can't go
beyond 265 pages) in Page Break Preview?

Thank you so much.

"Dave Peterson" wrote:

This blew up for me on the 1028th pagebreak:

Option Explicit
Sub testme()
Dim iCtr As Long

With ActiveSheet
On Error Resume Next
For iCtr = 2 To .Rows.Count
.HPageBreaks.Add befo=.Cells(iCtr, "A")
If Err.Number = 0 Then
'ok
Else
Err.Clear
MsgBox "Error with: " & iCtr & vbLf & iCtr - 1 & " worked ok"
Exit For
End If
Next iCtr
On Error GoTo 0
End With
End Sub




ps. I used xl2003.

Gord Dibben wrote:

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.

Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)

--

Dave Peterson

Thanks for your answear.

"Gord Dibben" wrote:

Barb

OP did not have the proper print range set. Once done, was able to get all
the pages needed.

I am able to get pagebreaks for A1:A65536 range in Excel 2003.

I can find no limit other than 65536 rows.


Gord

On Sun, 10 Aug 2008 13:55:00 -0700, Barb Reinhardt
wrote:

I believe there is a limit to the number of manual page breaks you can have.
(at least in 2003)