sequencial numbering in excel
Posted by Brian on June 28, 2001 2:55 PM
I have a one page form in excel, how can i print the form 50 or more times and have a number at the top increment by one each time.
Posted by Ivan F Moala on June 28, 2001 9:33 PM
Have a look @ Online help for application events.....
eg.
Private Sub Workbook_BeforePrint(Cancel As Boolean)
Dim IndexCount
IndexCount = ActiveSheet.Range("A1")
ActiveSheet.Range("A1") = IndexCount + 1
End Sub
Ivan
