Two Print Macros for One Worksheet

G

Guest

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
how to print only rows with data without inlcuding rows with a formula 3
Help on Macro to hide empty rows 4
How can I loop through a the values in multiple rows 6
Print Macro 5
Page Breaks in VBA Q 6
Print worksheets in external workbooks 2
After Macro runs, no cell activated - what am I missing? 2

Top