LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Dave Peterson
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Seed numbers for random number generation, uniform distribution darebo Excel Discussion (Misc queries) 3 April 21st 23 09:02 PM
Sorting alphanumeric numbers maurice.centner Excel Discussion (Misc queries) 2 May 6th 05 02:00 AM
Can I create an order summary report in Excel? kvo Excel Worksheet Functions 2 April 6th 05 12:37 AM
Sorting order - text and numbers jmt Excel Discussion (Misc queries) 2 April 4th 05 01:25 AM
create a flyer with vertical names and numbers at the bottom? meow Excel Discussion (Misc queries) 1 January 19th 05 05:17 PM


All times are GMT +1. The time now is 12:47 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"