| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two Print Macros for One Worksheet
I need to print two versions of one spreadsheet. One version needs to print
A1:M98. The other version needs to print A1:Z132. I have the following macro for A1:M98 - Sub Print_1() ' ' Print_1 Macro ' ActiveSheet.PageSetup.PrintArea = "$A$1:$m$98" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("A1:m98").Select End Sub Can I add another button to print A1:Z132, so I do not have to re-set the print area every time? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Two Print Macros for One Worksheet
I got it - I just added another macro Sub Print_2 and changed the parameters.
"heater" wrote: I need to print two versions of one spreadsheet. One version needs to print A1:M98. The other version needs to print A1:Z132. I have the following macro for A1:M98 - Sub Print_1() ' ' Print_1 Macro ' ActiveSheet.PageSetup.PrintArea = "$A$1:$m$98" ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True Range("A1:m98").Select End Sub Can I add another button to print A1:Z132, so I do not have to re-set the print area every time? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protecting a worksheet / workbook with macros | Excel Discussion (Misc queries) | |||
| Different print page setups on one worksheet? | Excel Worksheet Functions | |||
| How do I print a list of worksheet tab names in a workbook | Excel Worksheet Functions | |||
| How to print a worksheet but number the pages by workbook | Excel Discussion (Misc queries) | |||
| How to print invoices for each advertiser from Excel worksheet | Excel Worksheet Functions | |||
Linear Mode
