title: Make automatic page breaks ignore split cells in VBA in Excel
body: <p>Is it possible to generate automatic page breaks in VBA in Excel 2007 which ignore split cells (after merging adjacent cells)?</p>
  
  <p>For instance, in the example below I would like the page break to be above row 51, not cutting through the middle of the merged cell A51-A53.</p>
  
  <p><a href="https://i.stack.imgur.com/VFLYx.jpg" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/VFLYx.jpg" alt="enter image description here"></a></p>
  
  <p>The code I have tried is:</p>
  
  <pre><code>workSheet.Range("A2:A" &amp; bottomRow).PageBreak = xlPageBreakAutomatic
  </code></pre>
  
  <p>By only including column A in the range, I was hoping that it wouldn't generate a page break cutting through cells in this column.</p>