Printing Multiple Sheets that have a Specified Selection

**Excel"*"** · 12-03-2012, 11:19 AM

Hi All,

I'm using the following code to print a specified selection on a sheet, it works great. But now, I was to be able to use this code on 3 sheets and print all of them @ once.

Here is the code for the sheet.

Sub Print_AUR()

'This will print the AUR$ page

    Sheets("AUR $").Select
    Range("B28:F28").Select
    Range(Selection, Selection.End(xlDown)).Select
    ActiveSheet.PageSetup.PrintArea = Selection.Address
    Application.Dialogs(xlDialogPrint).Show

End Sub

Ideally, I could add another sheet called Retail GM into this code so when the user prints it would print both sheets while maintaing the selection.address part. That is very critical.

Any thoughts? Thanks for everyone's help in advance.