Export (0) Print
Expand All

Left Property

Office 2003

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.

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.

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.

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.

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

		
Show:
© 2015 Microsoft