Get page orientation of active sheet in Excel 2007
If a chart is selected in Excel 2007, using
ActiveSheet.PageSetup.Orientation doesn't seem to return the orientation
of the active sheet, but the orientation of the selected chart object
(whatever the meaning of this value is...?).
Is there another way to return the orientation of the active sheet (if
not programmatically unselect the chart shape first)?
Thanks
|