set some pages to be printed in portrait and some pages to be printed in landscape

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
---

Take a look at this link, here's a way round it

http://www.exceltip.com/st/Printing_...ayout/714.html

Originally Posted by oldchippy

Take a look at this link, here's a way round it

http://www.exceltip.com/st/Printing_...ayout/714.html

Hi oldchippy, I think the OP has a response in another forum with an Addin Print Manager, hopefully for good results.

---