title: Macro to Print Two Different Paper Sizes at Same Zoom
body: <p>I set up a macro to print a large data set. It doesn't fit all on one sheet (width-wise, it can extend height-wise as needed). It prints 2/3 of the data on an 11x17 (Macro1) and the remaining 1/3 on 8.5x11 (Macro2). To get it to fit properly, I am using the following:</p>
  
  <pre><code>    .Zoom = False
      .FitToPagesWide = 1
      .FitToPagesTall = False
  </code></pre>
  
  <p>Now, this works well enough. Unfortunately, when it scales it down, the scale is not the same for both sheets so you can't place the 8.5x11 next to the 11x17 and have the rows match up. Is there anyway to pass the zoom from one macro to the other? If you set <code>.FitToPagesWide</code>, then <code>.Zoom</code> just returns false. It should also be noted, that the data set may have an additional 2 to 4 columns added. So if I set a specific zoom for my sheets, I feel like it won't work in all cases. Ideally, I would like to just fit the 11x17 and have the 8.5x11 be at the same scale.</p>
  
  <p><em>EDIT</em> I used the accepted answer and deleted out a few unnecessary items for my macro. The final code is below:</p>
  
  <pre><code>    .Zoom = 60
      With ActiveSheet
          Do While .VPageBreaks.Count &gt; 2
              .PageSetup.Zoom = .PageSetup.Zoom - 1
              ActiveWindow.View = xlPageBreakPreview
              ActiveWindow.View = xlNormalView
          Loop
      End With
  </code></pre>
  
  <p><em>Edit 2</em> Current Code iteration includes a few steps to debug.</p>
  
  <pre><code>    With ActiveSheet
          i = 1
          .PageSetup.Zoom = 80
          Do While .VPageBreaks.Count &gt; 2
              .PageSetup.Zoom = .PageSetup.Zoom - 1
              ActiveWindow.View = xlPageBreakPreview
              ActiveWindow.View = xlNormalView
              Application.StatusBar = "Zooming Iteration #" &amp; i &amp; " :: Zoom at " &amp; .PageSetup.Zoom
              i = i + 1
          Loop
          Application.StatusBar = False
      End With
  </code></pre>