Numbering series

[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.

 

[L. Howard Kittle]

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