TopLeftCell Property

Applies To

Arc Object, Button Object, ChartObject Object, CheckBox Object, Drawing Object, DropDown Object, EditBox Object, GroupBox Object, GroupObject Object, Label Object, Line Object, ListBox Object, OLEObject Object, OptionButton Object, Oval Object, Picture Object, Rectangle Object, ScrollBar Object, Spinner Object, TextBox Object.

Description

Accessor. Returns a Range object that represents the cell that lies under the top left corner of this object. For drawing objects, this property applies only when the drawing object is on a worksheet. Read only.

See Also

BottomRightCell Property.

Example

This example displays the address of the cell beneath the upper-left corner of rectangle one on Sheet1.


MsgBox "The top left corner is over cell " & _
    Worksheets("Sheet1").Rectangles(1).TopLeftCell.Address