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