Rotate one page of many when printing?

[Brian F]

Excel 2010, Windows 10: I have a VBA routine that chooses which worksheets (by worksheet name) to print out of many possible choices in a workbook. One of those sheets (Invoice_(Developer)) I want to rotate 180 degrees before it prints. Is there any way to include a switch in the statement...;

ActiveWindow.SelectedSheets.PrintOut Copies:=1, Collate:=True, _
IgnorePrintAreas:=False

....that would rotate that one sheet? From my search on the internet it would seems the answer is "no" but I've learned that there may well be one of you who has a solution so I thought I ask.

Thanks for any input you're able to give me.

 

[mole999]

I've not seen it done in one routine, and my attempts in the past haven't worked, but a daft idea occurs to me

replicate the sheet, but have all the text turned 90 degrees (i presume you meant 90 and not inverted), adjust to fit as if columns and rows were realigned, if your lucky transpose might work, cells will need to point to original values

 

[SpillerBD]

Why isn't the Page Setup for that Sheet set to Landscape?