Home |
Search |
Today's Posts |
#5
![]() |
|||
|
|||
![]()
Do you want the page numbers placed in a cell?
If yes, you could run a macro that prints the 50 copies: Option Explicit Sub testme01() Dim iCtr As Long With Worksheets("sheet1") With .Range("a1") .NumberFormat = "000" For iCtr = 1 To 50 .Value = iCtr .Parent.PrintOut preview:=True Next iCtr End With End With End Sub If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Mark wrote: Unlike page numbers I need to print out 50 copies of the same page. Each order form would have a different number; 001, 002, 003, etc. "Anne Troy" wrote: What do you mean "Pages"? You can add page numbers to your headers or footers by hitting View--Header and Footer. ******************* ~Anne Troy www.OfficeArticles.com www.MyExpertsOnline.com "Mark" wrote in message ... I am attempting to create an order form with incremental order numbers. When I print a number of pages I would like each page to have a new number, increased by 1, from the page before. -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Seed numbers for random number generation, uniform distribution | Excel Discussion (Misc queries) | |||
Sorting alphanumeric numbers | Excel Discussion (Misc queries) | |||
Can I create an order summary report in Excel? | Excel Worksheet Functions | |||
Sorting order - text and numbers | Excel Discussion (Misc queries) | |||
create a flyer with vertical names and numbers at the bottom? | Excel Discussion (Misc queries) |