If you are printing your first page from "Sheet1" and the next page from "Sheet2." Then your "Page Setup" will atuomatically control the print for each page independently. So just set the page options for each sheet. Record a macro and use the print icon to print each page and you are done.
If you need to print multiple pages from the same sheet or you need to set options in your code (this slows down printing alot!), then you need to control the print flow.
Record a macro:
Set the first page, print range select the options, print. Then select the rest of the sheet, but not the part you just printed, set your options like landscape. Then print the selection. Stop the macro recorder. You may need to edit out some of the print code from the recorded macro, as the Excel recorder is particularly dirty when it comes to recording printer code. JSW