Hi
I've got a one page excel document, basically it's a one sheet form. I need to print about 100 copies each individually numbered. I know if
the form was 100 pages in total I could easily auto number each printed page. Does anyone know a way to do this, I've spent a bit of time
searching google and whilst it seems possible, it looks as though you need to write some code?? which seems a bit beyond my excel skills.
Thanks Andy
not sure if it will work but I would cheat.
Install a Free PDF printer eg cute pdf then print 100 copies to the PDF printer. then when you print the 100 pages to your proper printer you should
be able to switch on ' Print Page numbers '
option 2 if the form is not too complicated patse it into word ans do a simple mail merge for your page number
regards
agriv8
not really up on it just had a look at print preview and ther is a box that says first page number I wonder if you put a 1 in if it will automatically number from there worth a try at setting it to 1 and printing 4 pages to see if they do get numbered
As above - Excel does it for you
Print Preview - Custom Footer
then click on the page number format you require
eg Page 1 etc or Page 1 of XX
You're going to need a bit of code....
Written for you here:
LINKY
The header idea will just print "1" 100 times. Try this instead: -
Put "1" in a cell somewhere on your worksheet where you'd like the page number to be. Then create the following macro (substitute A1
for wherever your number should go): -
For i = 1 To 5
Range("A1"
.Value = i
ActiveWindow.SelectedSheets.PrintPreview
Next i
Run it and you'll get 5 print previews, which hopefully look like you want.
When you're happy, change 5 to 100 and PrintPreview to PrintOut.
Bish bash bosh, bob's your dog.
Hi
Thanks for the replys, when I started started this afternoon I thought it would be simple. I'll try creating the macro, never done any before
though. I found some info on code's earlier today, is that were you use alt f11? that's as far as I got, I need step by step instructions to
follow that.
Andy
cheers Andy
Tools...Macro...Macros...
Type a name (anything)
Click Create
Paste the code
Press the Play button
Simples 
quote:
Originally posted by Andy W
Hi
Thanks for the replys, when I started started this afternoon I thought it would be simple. I'll try creating the macro, never done any before though. I found some info on code's earlier today, is that were you use alt f11? that's as far as I got, I need step by step instructions to follow that.
Andy
cheers Andy
Hi
Thanks for the help, I basically understand what I have to do now, just can't get it to work. Keep getting errors
Andy