Left Property [Excel 2003 VBA Language Reference]
Left property as it applies to the Application object.
The distance, in points, from the left edge of the screen to the left edge of the main Microsoft Excel window. Read/write Double.
expression.Left
expression Required. An expression that returns one of the above objects.
Left property as it applies to the Window object.
The distance, in points, from the left edge of the client area to the left edge of the window. Read/write Double.
expression.Left
expression Required. An expression that returns one of the above objects.
Left property as it applies to the AxisTitle, ChartObject, ChartObjects, ChartTitle, DataLabel, DisplayUnitLabel, Legend, OLEObject, OLEObjects, and PlotArea objects.
The distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart). Read/write Double.
expression.Left
expression Required. An expression that returns one of the above objects.
Left property as it applies to the Axis, ChartArea, LegendEntry, and LegendKey objects.
The distance, in points, from the left edge of the object to the left edge of the chart area. Read-only Double.
expression.Left
expression Required. An expression that returns one of the above objects.
Left property as it applies to the Shape and ShapeRange objects.
The distance, in points, from the left edge of the object to the left edge of column A (on a worksheet) or the left edge of the chart area (on a chart). Read/write Single.
expression.Left
expression Required. An expression that returns one of the above objects.
Left property as it applies to the Range object.
The distance, in points, from the left edge of column A to the left edge of the range. If the range is discontinuous, the first area is used. If the range is more than one column wide, the leftmost column in the range is used. Read-only Variant.
expression.Left
expression Required. An expression that returns one of the above objects.
If the window is maximized, Application.Left
returns a negative number that varies based on the width of the window border. Setting Application.Left
to 0 (zero) will make the window a tiny bit smaller than it would be if the application window were maximized. In other words, if Application.Left
is 0 (zero), the left border of the main Microsoft Excel window will just barely be visible on the screen.
Example
This example aligns the left edge of the embedded chart with the left edge of column B.
With Worksheets("Sheet1")
.ChartObjects(1).Left = .Columns("B").Left
End With
Applies to | Application Object | Axis Object | AxisTitle Object | ChartArea Object | ChartObject Object | ChartObjects Collection Object | ChartTitle Object | DataLabel Object | DisplayUnitLabel Object | Legend Object | LegendEntry Object | LegendKey Object | OLEObject Object | OLEObjects Collection Object | PlotArea Object | Range Collection | Shape Object | ShapeRange Collection | Window Object
See Also | Height Property | Top Property | Width Property