Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have created a blank form in Excel and I want to print 100 today and number
them sequentially. Next month, I want to start with number 101 and number sequentially. Can I format this to print with a different number on each form |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Try sth like this:
In the code module for the workbook: Private Sub Workbook_BeforePrint(Cancel As Boolean) Worksheets("Sheet1").Range("A1") = Worksheets("Sheet1").Range("A1") + 1 End Sub In a standard module: Sub PrintMe() i = 1 For i = 1 To 100 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next i End Sub In A1 enter 0 and then run PrintMe Hope you get the idea,adjust to your needs. knut "Ferree" skrev i melding ... I have created a blank form in Excel and I want to print 100 today and number them sequentially. Next month, I want to start with number 101 and number sequentially. Can I format this to print with a different number on each form |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Baffling! Spreadsheet Data Form Size | Excel Discussion (Misc queries) | |||
Pleeze Help! Export Excel data into a form in a Word Doc...this one's tough! | Excel Discussion (Misc queries) | |||
Automatically display sentence. | New Users to Excel | |||
sequential numbering of copies printed | Excel Worksheet Functions | |||
Sequential numbering | Excel Discussion (Misc queries) |