| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Print a single sheet in Excel with consecutive page numbers
I have a single worksheet that I need to print about 50 copies. I need the
copies numbered. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Print a single sheet in Excel with consecutive page numbers
Ron de Bruin macro.
Sub PrintCopies() Dim i As Long For i = 1 To 50 With ActiveSheet .PageSetup.LeftFooter = "#" & i .PrintOut End With Next End Sub Gord Dibben MS Excel MVP On Wed, 1 Nov 2006 08:53:02 -0800, cmompoohu wrote: I have a single worksheet that I need to print about 50 copies. I need the copies numbered. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel page setup Sheet Print Cells Error As... | Excel Discussion (Misc queries) | |||
| How do I in excel print consecutive numbers from one form? | Excel Discussion (Misc queries) | |||
| Active cell counting in particular print page (one sheet having different print area) | Excel Worksheet Functions | |||
| Page Numbers | Excel Discussion (Misc queries) | |||
| print 1 long row(20 columns) in excel to one single page | Excel Worksheet Functions | |||
Linear Mode
