Range.End Property (Excel)
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.
expression A variable that represents a Range object.
The direction in which to move.
This example selects the cell at the top of column B in the region that contains cell B4.
This example selects the cell at the end of row 4 in the region that contains cell B4.
This example extends the selection from cell B4 to the last cell in row four that contains data.