ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Removing automatic(Default) page break (https://www.excelbanter.com/excel-programming/429081-removing-automatic-default-page-break.html)

ironhydroxide

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

ironhydroxide

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.

ironhydroxide

Removing automatic(Default) page break
 
Sorry error on last post was '9' Subscript out of range



All times are GMT +1. The time now is 04:11 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com