| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Progressive numbering of Excel worksheets
Is it possible to print multiple copies of an Excel worksheet with progressive
numbers |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Progressive numbering of Excel worksheets
This macro might help
Sub Macro1() Application.ScreenUpdating = False For j = 1 To 5 ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("E20") = Range("E20") + 1 Next j Application.ScreenUpdating = True End Sub best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "Sdorph" wrote in message ... Is it possible to print multiple copies of an Excel worksheet with progressive numbers |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Overview Improvements for Excel Worksheets | Excel Discussion (Misc queries) | |||
| How to Set background color XLM Excel worksheets in Netscape andFirefox browsers | Excel Discussion (Misc queries) | |||
| Combine worksheets from different excel files into one excel file | Excel Discussion (Misc queries) | |||
| How do you protect hidden linked worksheets with in an Excel workb | Excel Discussion (Misc queries) | |||
| Excel Range Value issue (Excel 97 Vs Excel 2003) | Excel Discussion (Misc queries) | |||
Linear Mode
