Hi there,

I have a code that is selecting 4 columns and creating a print area. Columns A-B & Columns D-E. Column C is hidden.

When I go to print the selected print area it will print columns A-B on one page and D-E on another page.

May I have some help with a code that can print the two areas on one page so that the printout shows A, B, D, E with the running of the macro automatically printing the page as shown in my current code.
The current code I am using is:
myRange = Selection.Address
    ActiveSheet.PageSetup.PrintArea = myRange
    ActiveWindow.SelectedSheets.PrintOut Copies:=1
    ActiveSheet.PageSetup.PrintArea = ""

Many thanks in advance!!