Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing automatic(Default) page break
I am wondering how one removes an automatic, or default, page break. I can
insert the break at the correct place. but i am creating the sheet earlier in the macro and am not sure where the page break would be. thanks for the help ironhydroxide |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing automatic(Default) page break
Here is some code that i have used, it always gives me an error
BreakNum=1 Worksheets("Picture Board Zones").HPageBreaks(BreakNum).Location = Worksheets("Picture Board Zones").Range("A" & (RowLoopOne + 1)) Here i am trying to move the Page Brake to a different place instead of deleting the default page break. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Removing automatic(Default) page break
Sorry error on last post was '9' Subscript out of range
|
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
automatic page break | Excel Discussion (Misc queries) | |||
Removing A Vertical Page Break That Won't Go! | New Users to Excel | |||
Removing Page Break Preview from all spreadsheets | Excel Discussion (Misc queries) | |||
Removing a page break from excel | Excel Worksheet Functions | |||
Automatic page break | Excel Programming |