Orientation Property
Orientation property as it applies to the TextFrame object.
The text frame orientation. Can be an integer value from – 90 to 90 degrees or one of the MsoTextOrientation constants. Read/write MsoTextOrientation.
| MsoTextOrientation can be one of these MsoTextOrientation constants. |
| msoTextOrientationDownward |
| msoTextOrientationHorizontal |
| msoTextOrientationHorizontalRotatedFarEast |
| msoTextOrientationMixed |
| msoTextOrientationUpward |
| msoTextOrientationVertical |
| msoTextOrientationVerticalFarEast |
expression.Orientation
expression Required. An expression that returns a TextFrame object.
Orientation property as it applies to the Style object.
The text orientation. Can be an integer value from – 90 to 90 degrees or one of the XlOrientation constants. Read/write XlOrientation.
| XlOrientation can be one of these XlOrientation constants. |
| xlDownward |
| xlUpward |
| xlHorizontal |
| xlVertical |
expression.Orientation
expression Required. An expression that returns a Style object.
Orientation property as it applies to the PageSetup object.
Portrait or landscape printing mode. Read/write XlPageOrientation.
| XlPageOrientation can be one of these XlPageOrientation constants. |
| xlPortrait |
| xlLandscape |
expression.Orientation
expression Required. An expression that returns a PageSetup object.
Orientation property as it applies to the CubeField and PivotField objects.
The location of the field in the specified PivotTable report. Read/write XlPivotFieldOrientation.
| XlPivotFieldOrientation can be one of these XlPivotFieldOrientation constants. |
| xlColumnField |
| xlDataField |
| xlHidden |
| xlPageField |
| xlRowField |
expression.Orientation
expression Required. An expression that returns one of the above objects.
Orientation property as it applies to the TickLabels object.
The text orientation. Can be an integer value from – 90 to 90 degrees or one of the XlTickLabelOrientation constants. Read/write XlTickLabelOrientation.
| XlTickLabelOrientation can be one of these XlTickLabelOrientation constants. |
| xlTickLabelOrientationAutomatic |
| xlTickLabelOrientationHorizontal |
| xlTickLabelOrientationVertical |
| xlTickLabelOrientationDownward |
| xlTickLabelOrientationUpward |
expression.Orientation
expression Required. An expression that returns a TickLabels object.
The text orientation. Can be an integer value from – 90 to 90 degrees. Read/write Variant.
expression.Orientation
expression Required. An expression that returns one of the above objects.
Remarks
For OLAP data sources, setting this property for one field in a hierarchy sets the orientation for the other fields in the same hierarchy. Dimension fields can only be oriented in the row, column, and page field areas of the PivotTable report. Measure fields can only be oriented in the data area. Setting a hierarchy or data field to xlHidden removes the hierarchy or field from the PivotTable report.
Example
As it applies to the
PivotField object.
This example displays the orientation for the ORDER_DATE field.
Set pvtTable = Worksheets("Sheet1").Range("A3").PivotTable
Set pvtField = pvtTable.PivotFields("ORDER_DATE")
Select Case pvtField.Orientation
Case xlHidden
MsgBox "Hidden field"
Case xlRowField
MsgBox "Row field"
Case xlColumnField
MsgBox "Column field"
Case xlPageField
MsgBox "Page field"
Case xlDataField
MsgBox "Data field"
End SelectAs it applies to the
PageSetup object.
This example sets Sheet1 to be printed in landscape orientation.
Worksheets("Sheet1").PageSetup.Orientation = xlLandscape