I have a workbook with 2 worksheets, "Summary" and "Result"

I have in a macro a command to print each worksheet. I want to print "Summary" normally, but I would like to print "Result" as 2 pages to a sheet. At present I have "solved" the problem by replacing the command line to Print "Result" with a PrintPreview command. Then I manually print and in the printer dialog box change the properties to printing 2 pages per sheet.

My question is: can I do this automatically in code so that I don't have to manually change to "2 pages per sheet" every time I Print "Result"?

Thanks for any help

Free