BottomRightCell 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 bottom right corner of the object. For drawing objects, this property applies only when the drawing object is on a worksheet. Read-only.

See Also

TopLeftCell Property.

Example

This example displays the address of the cell beneath the lower-right corner of rectangle one on Sheet1.


MsgBox "The bottom right corner is over cell " & _
    Worksheets("Sheet1").Rectangles(1).BottomRightCell.Address