I am creating a two page device status report in Excel. VBA code will be run to populate the fields of the report and save a the report as a file - one for each device listed in the database (approx. 1000). It is necessary for me to print each of these reports for our contractors, and desireable that each two page report be printed on a single page (front and back).

The issue is that the first page needs to print in a Portrait format, and the second in Landscape format. Is it possible to print two pages of the same worksheet back-to-back AND have each side in the desired format(portrait/landscape). Any suggestions to accomplish this are greatly appreciated.