Sequential Numbering of Invoices when Printing

[WarrenC]

I am building an invoice and I need to sequentially number them as they print. I was thinking of using the page number feature, but I cant figure out how to get it into a specific cell. So if I decide to print a hundred invoices, they come off the printer No 1, No 2, No 3 etc. Again, I need this in a specific cell. Can this be done???

[oldchippy]

May be this link will help?

http://www.mcgimpsey.com/excel/udfs/sequentialnums.html

[WarrenC]

found some vb code on the net and got it working. Thanks to all

Private Sub Workbook_BeforePrint(Cancel As Boolean)
If ActiveSheet.Name = "Summary" Then Range("A1").Value = Range("A1").Value + 1
End Sub

Private Sub Workbook_Open()

End Sub

As long as your sheet is called Summary, the numbers in cell A1 change everytime you print (or print preview)

[jkhayes]

How about sharing an example of what it looks like?

[shg]

Warren, please wrap the code in your post with code tags. If you don't know how, please read the forum rules.