Quote Originally Posted by Pacman
Hi,

How to set some pages to be printed in landscape in the same document? Currently I have to use page break and print the portrait and landscape pages separately, but it's quite troublesome and easy to make mistake. Is there a way to do it like we can do in Word?

Thanks for your help...
I believe not.

A macro is possible, but if the range (number of rows) changes then it could be difficult.

An option is to extract the Portrait data data to another worksheet, print it separatly, then interleave the pages.

Another option is to extract to 3 other sheets, and print from there.

hth
---