Do you have the help files installed?
End Property
See AlsoApplies ToExampleSpecificsReturns 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 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
