Portrait & Landscape on the same tab

**stemcell1** · 03-16-2009, 03:59 PM

I have a single tab that I need to have some portions be landscape and some be portrait, and I need it to print out in the correct order. Does anyone know how to do that?

Thanks!!

**shg** · 03-16-2009, 05:07 PM

You would need to change the print area and page setup between printing each section. If the pages were numbered in the header or footer and you need them to appear continuous over the different sections, you also need to change the first page number in page setup.

If you're looking for this to be automated via VBA, please post in the programming forum with a link to this thread, and post a workbook with further explanation.

**Kankuroo** · 08-23-2016, 09:07 AM

Hi stemcell1, have the same problem, did you find a way to achieve this?

Thanks,

**Kankuroo** · 08-23-2016, 09:18 AM

Hi stemcell1, have the same problem, did you find a way to achieve this?

Thanks,

Actually, I found the answer here: http://www.vbaexpress.com/forum/show...same-worksheet