Removing automatic(Default) page break

I

ironhydroxide

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
 
I

ironhydroxide

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top