Hi,

I have an excel workbook with 30+ worksheets. I have code which copies each worksheet into one new word document but my issue is that each worksheet has a different layout orientation whether it be landscape or portrait and i need that orientation to transfer to the word document as well. So the word document will be a combination of portrait and landscape layouts. Any ideas?