Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.setup
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i extend the printable area up to the very last row
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? |
#3
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i extend the printable area up to the very last row
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) |
#4
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i extend the printable area up to the very last row
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 |
#5
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i extend the printable area up to the very last row
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 test<g 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) |
#6
Posted to microsoft.public.excel.setup
|
|||
|
|||
how can i extend the printable area up to the very last row
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 now<g 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 test<g 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) |
#7
Posted to microsoft.public.excel.setup
|
|||
|
|||
Hi Barb
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? |
#8
Posted to microsoft.public.excel.setup
|
|||
|
|||
Hi Dave
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 |
#9
Posted to microsoft.public.excel.setup
|
|||
|
|||
Hi Gord
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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using named range to extend print area for variable number of columns | Excel Worksheet Functions | |||
Create a printable FORM | Excel Worksheet Functions | |||
Replace non printable characters | Excel Worksheet Functions | |||
Set Printable area to skip columns | Excel Discussion (Misc queries) | |||
Non-Printable Worksheets | Excel Discussion (Misc queries) |