Left Property
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