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 |
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. |
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