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.
|Direction||Required||xlDirection||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.
Worksheets("Sheet1").Activate Range("B4", Range("B4").End(xlToRight)).Select
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.