Range.End Property

Syntax

expression.End(Direction)

expression A variable that represents a Range object.

Parameters

Name	Required/Optional	Data Type	Description
Direction	Required	XlDirection	The 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`

end end property Using Parentheses in code

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.