Export (0) Print
Expand All
Expand Minimize

Range.End Property

Office 2007
Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW. Read-only Range object.

Syntax

expression.End(Direction)

expression   A variable that represents a Range object.

Parameters

NameRequired/OptionalData TypeDescription
DirectionRequiredXlDirectionThe direction in which to move.

Example

This example selects the cell at the top of column B in the region that contains cell B4.

Visual Basic for Applications
Range("B4").End(xlUp).Select

This example selects the cell at the end of row 4 in the region that contains cell B4.

Visual Basic for Applications
Range("B4").End(xlToRight).Select

This example extends the selection from cell B4 to the last cell in row four that contains data.

Visual Basic for Applications
Worksheets("Sheet1").Activate
Range("B4", Range("B4").End(xlToRight)).Select



Community Additions

ADD
Show:
© 2014 Microsoft