| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How to print from consecutive numbers in excel w/o typing all?
I need to print about 700 tickets and I have to number each of them. Is there
a way I can use a formula in order for it to print the numbers on each sheet without having to type each number before printing? Thank you. |
|
#2
|
|||
|
|||
|
How to print from consecutive numbers in excel w/o typing all?
Here is a macro that should help. Try it with FOR j = 1 to 5 first, then
change to 700 Note that I assume your number is in A1; change code as needed Write to me at my personal email for more. Sub PrintTicket() For j = 1 To 5 Range("A1") = j ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Next End Sub best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Need help in Excel" <Need help in wrote in message ... I need to print about 700 tickets and I have to number each of them. Is there a way I can use a formula in order for it to print the numbers on each sheet without having to type each number before printing? Thank you. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
| print view & print, in excel, different size cells | Excel Discussion (Misc queries) | |||
| Varying page Excel report | Excel Discussion (Misc queries) | |||
| I cannot print out Excel documents. I can print emails. | Excel Discussion (Misc queries) | |||
| Set "print all text as black" as default in Excel | Excel Worksheet Functions | |||
Linear Mode
