Printing a worksheet in Portrait and Landscape

[stroffso]

Hi,

I have a worksheet where I want to print Cells A1:M36 in Portrait orientation but then also print cells A38:A69 in landscape orientation. I cant seem to be able to do this through normal measures so would anyone have some code I can use to do this instead?

thanks in advance

 

[RedBeard]

This should lead you in the right direction: https://msdn.microsoft.com/en-us/library/office/ff839804.aspx

 

[stroffso]

Thank you very much that helps a great deal