title: Remove Automatic Page Breaks in VBA
body: <p>Does anyone know whether you can remove automatic page breaks in Excel VBA?  I finally found an article that says that you cannot, but I'd like to confirm.  I'm a little disappointed that this can't be accomplished in VBA. </p>
  
  <p>This code, in a subroutine, seems to be able to remove user-inserted or manual page breaks, but not ones inserted by Excel automatically. </p>
  
  <pre><code>For nCtr = 1 To ActiveSheet.HPageBreaks.Count
      ActiveSheet.HPageBreaks(1).DragOff Direction:=xlUp, RegionIndex:=1
  Next
  
  For nCtr = 1 To ActiveSheet.VPageBreaks.Count
      ActiveSheet.VPageBreaks(1).DragOff Direction:=xlToRight, RegionIndex:=1
  Next
  </code></pre>
  
  <p>Thoughts?</p>