Macro to print multiple print areas on one page.

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!!

Bump no response

I'm pretty sure I either asked this here before or found the answer in these here parts somewhere. Unfortunately there is no way to do what you want to do, or rather not in the way you have outlined. It will always print on separate sheets sadly. There were some answers with cutting and pasting via macros into one sheet, or you could set up another sheet with links missing column C. One question though - if column C is hidden can't you just make it one print area? I don't think the hidden column will print anyway.