Export (0) Print
Expand All
Expand Minimize

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 .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.

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
Show:
© 2014 Microsoft