title: How to increment number in a cell after printing on excel
body: <p>I was wondering if some one can help me. I need to increment by one a number in a cell and then clean a few textbox but after the printing. There is an beforeprint event but doesnt do what I want becuase before the sheet is printed all the data is cleaned, obviously (I apologize for my english) Is there a way to do what I need or a better practice for it. Thank you.</p>
  
  <pre><code>Private Sub Workbook_BeforePrint(Cancel As Boolean)
   [I6] = [I6] + 1
   [C11] = ""
   [C12] = ""
   Range("B16:B27").ClearContents
   Range("C16:C27").ClearContents
   Range("D16:D27") = ""
   Range("H16:H27").ClearContents
  End Sub
  </code></pre>