Page orientation

[njakfla]

Hello all,

is it possible something using VBA change orientation on 2nd page?
I added page break between first and second page, but i want to change orientation on 2nd page for printing because table is totally visible.

 

[Joe4]

Welcome to the Board!

I think if you want the data all on one sheet, and want them to ahve different columns and orientations when printing, you will need to do it in two steps.
Set up the print range and orientation for the first page only, then print that.
Then, set up the print range and orientation for the rest of the data, and then print that.
You could set all that up in VBA (so you actually will have two separate print commands).

Another alternative would be to split up your file into two sheets.
So the first sheet would just have what you show for page 1, and the second sheet would have the rest of the data.
Then you can set up the print range and orientation for each sheet independently, and then print each sheet.

 

[njakfla]

Welcome to the Board!

I think if you want the data all on one sheet, and want them to ahve different columns and orientations when printing, you will need to do it in two steps.
Set up the print range and orientation for the first page only, then print that.
Then, set up the print range and orientation for the rest of the data, and then print that.
You could set all that up in VBA (so you actually will have two separate print commands).

Another alternative would be to split up your file into two sheets.
So the first sheet would just have what you show for page 1, and the second sheet would have the rest of the data.
Then you can set up the print range and orientation for each sheet independently, and then print each sheet.

Thank you for the replay,
i actually made similar solution. I created 2 different workbooks, but i think i will follow your logic to put it in 2 different sheets inside 1 workbook
and use sheets as pages.
Thank you again!

 

[Joe4]

You are welcome.
Glad I was able to help!