Left Property
This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
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 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.
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