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.End(Direction)
expression Required. An expression that returns one of the objects in the Applies To list.
Direction Required XlDirection. The direction in which to move.
| XlDirection can be one of these XlDirection constants. |
| xlDown |
| xlToRight |
| xlToLeft |
| xlUp |
Example
This example selects the cell at the top of column B in the region that contains cell B4.
Range("B4").End(xlUp).Select
This example selects the cell at the end of row 4 in the region that contains cell B4.
Range("B4").End(xlToRight).Select
This example extends the selection from cell B4 to the last cell in row four that contains data.
Worksheets("Sheet1").Activate
Range("B4", Range("B4").End(xlToRight)).Select