title: Printing from Excel VBA
body: <p>Trying to print the same excel sheet a number of times (e.g 100) with a cell incremented each time (e.g cell 4F).</p>
  
  <p>I tried using </p>
  
  <blockquote>
    <p>Workbook_BeforePrint</p>
  </blockquote>
  
  <p>to increment the cell, but it requires interaction with the "select printer" dialog for each printed sheet. </p>
  
  <p>Would it be possible to make something like:</p>
  
  <pre><code>a = getIntegerUserInput()
  for i in 1..a
     increment 4F with one
     print the sheet suppressing the "select printer" dialog
  end for
  </code></pre>
  
  <p>Cheers</p>