| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how do you print single page multiply times with increasing page .
How do you print a single page multiply times with increasing page numbers?
|
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you print single page multiply times with increasing page .
Probably easiest by manually entering "Page" in a bottom cell, then do some
code on the back end. For i = 1 to 20 Range("G40").Value = i ActiveWindow.SelectedSheets.PrintOut From:=1, To:=1, Copies:=1, Collate _:=True Next i assuming G40 is where you put the 1 and you want 20 pages. "aliasmith" wrote: How do you print a single page multiply times with increasing page numbers? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
how do you print single page multiply times with increasing page .
See Ron de Bruin's site for code.
http://www.rondebruin.nl/print.htm#same Gord Dibben MS Excel MVP On Thu, 25 Sep 2008 14:21:02 -0700, aliasmith wrote: How do you print a single page multiply times with increasing page numbers? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to print a form multiple times on one page | Excel Discussion (Misc queries) | |||
| Can you print separate worksheet on a single page? | Excel Discussion (Misc queries) | |||
| how to print a page many times but add a unique reference on each | Excel Worksheet Functions | |||
| How can i print 1 page many times with diferent reference number ? | Excel Discussion (Misc queries) | |||
| How do I print the same sheet multiple times with increasing page. | Excel Discussion (Misc queries) | |||
Hybrid Mode
