View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
ironhydroxide ironhydroxide is offline
external usenet poster
 
Posts: 51
Default 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.