Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to progresively number multiple copies
Is it possible to print multiple copies of a worksheet with a progressive
page number on each copy |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to progresively number multiple copies
If you have the page number in a worksheet cell, you could provide a macro that
increments that cell and prints the page: Option Explicit sub testme() dim iCtr as long with worksheets("sheet1") for iCtr = 1 to 10 .range("a1").value = ictr .printout preview:=true next ictr end with end sub I used A1 and did a print preview to save paper. If you're new to macros, you may want to read David McRitchie's intro at: http://www.mvps.org/dmcritchie/excel/getstarted.htm Sdorph wrote: Is it possible to print multiple copies of a worksheet with a progressive page number on each copy -- Dave Peterson |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
is it possible to progresively number multiple copies
Or without a page number in a cell.
Sub PrintCopies() Dim i As Long For i = 1 To 3 With ActiveSheet .PageSetup.LeftFooter = "Page " & i .PrintOut preview:=True '.Printout End With Next End Sub Gord Dibben MS Excel MVP On Mon, 18 Sep 2006 21:15:02 -0700, Sdorph wrote: Is it possible to print multiple copies of a worksheet with a progressive page number on each copy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
make multiple copies of a sheet in a new workbook | Excel Worksheet Functions | |||
how to multiple the rows by a given number | Excel Discussion (Misc queries) | |||
Return SEARCHED Column Number of Numeric Label and Value | Excel Worksheet Functions | |||
multiple copies of same workbook | Excel Discussion (Misc queries) | |||
Rounding a number to a multiple quantity that adds to a fixed total number | Excel Worksheet Functions |