Repeating pages

  • Thread starter Thread starter Christine
  • Start date Start date
C

Christine

Hi all!

Is there any way that I can repeat the same page about 100
times with a header reflecting the page number?
I need to print out one page 100 times, but would like
each page to be numbered 1- 100.
HELP!
Thanks!
 
Totally crazy and off the wall, but I tried it and it does work!
I didn't actually print, but Print Preview showed that every thing was as
you wished.

Go to Tools - Options and change default pages in new WBs to 100.
Open a new WB,
Copy your form into this new, big WB.
Select the entire master form and copy,
Select all your 100 sheets and Paste,
While everything is still selected, go to Page Setup and copy the formats to
all the sheets,
Go to File - Print - and click on Print Entire WorkBook,
Click OK - and cross your fingers!

Also, when I went to copy formats into the 100 sheets, my machine took what
felt like at least a minute, so be patient.
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
 
I'm having trouble changing the setting for default pages
to 100. Is this in Excel? or the printer options? Either
one, I still can't find it.
I am runnig on Windows NT.
Is there no easier way?

Thanks
 
Christine,

Believe me, if *I* knew of an easier way, I would gladly share it!

In XL - <Tools> <Options> <General> tab,
Middle of the window - "Sheets In New WorkBook",
Enter 100 in the small box beside it,
Then click <OK>.

Do you know how to handle the rest of this crazy suggestion ?
--


Regards,

RD
 
I'd use a little macro:

Option Explicit
Sub testme01()
Dim iCtr As Long
With Worksheets("sheet1")
For iCtr = 1 To 100
.PageSetup.RightHeader = "Page " & iCtr
.PrintOut preview:=True
Next iCtr
End With
End Sub

If you record a macro when you change the header, you should be able to steal
the line that you need (and the words that you want). I used the .rightheader
and just "Page ". (I also used Sheet1.)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm
 
And remove the Preview:=true when you're done testing.

(start with a small number and save a few trees, too <vbg>.)
 
Back
Top