Left Property

  • Article

Left property as it applies to the ChartSpace, ChCategoryLabel, ChChartField, ChDataLabel, ChDataLabels, ChErrorBars, ChLegendEntry, ChPoint, ChSeries, ChTrendline, PivotAggregate, PivotAxisMember, PivotColumnMember, PivotDetailCell, PivotPageMember, PivotResultAxis, PivotResultColumnAxis, PivotResultDataAxis, PivotResultFilterAxis, PivotResultGroupAxis, PivotResultLabel, PivotResultPageAxis, PivotResultRowAxis, PivotRowMember, and PivotTable objects.

Returns (or sets, depending on the object) a Long that represents the left edge of the specified object. Read/write.

expression.Left

*expression   * Required. An expression that returns one of the above objects.

Left property as it applies to the ChScrollView object.

Returns a Long that represents the left edge of the ChScrollView object. Read-only.

expression.Left

*expression   * Required. An expression that returns a ChScrollView object.

Left property as it applies to the PivotData object.

Returns or sets a PivotColumnMember object that represents the member immediately above the leftmost visible column. Read/write.

expression.Left

*expression   * Required. An expression that returns a PivotData object.

Left property as it applies to the Range object.

Returns a Variant that represents the distance from the left edge of the spreadsheet to the left edge of the specified range. This value can be negative if the range is outside the visible range. Read-only.

expression.Left

*expression   * Required. An expression that returns a Range object.

Left property as it applies to the Window object.

Returns a Double that represents the left edge of the specified window. Read-only.

expression.Left

*expression   * Required. An expression that returns a Window object.

Remarks

The only time any chart element coordinate is writeable is during the AfterLayout event of the ChartSpace object. Outside of this event, the Left property is read-only.

Example

This example scrolls to the left through the spreadsheet window to display cell F1 if this cell is currently to the left of the visible range.

Sub ScrollSheet

   Dim rngScroll

   Set rngScroll = Spreadsheet1.Range("f1")

   If rngScroll.Left < 0 Then Spreadsheet1.ActiveSheet.Scroll rngScroll

End Sub