Numbering series

  • Thread starter Thread starter Jim Martin
  • Start date Start date
J

Jim Martin

I have a template that is used for estimating, need to be
able to set-up my template to automatically issue the next
number in a series so that each saved estimate has a new
number in a specific cell on the template. I am unable to
find any thing in Excel help, or maybe I am not asking the
right questions.
 
Hi Jim,

There are many ways to do that depending on a few things. Seems most
recommend advancing the number with a before print event macro.

Private Sub Workbook_BeforePrint(Cancel As Boolean)
Range("A1").Value = Range("A1").Value + 1
End Sub

HTH
Regards,
Howard
 
Back
Top