Range.End Property

Returns a Range object that represents the cell at the end of the region that contains the source range.

Namespace:  Microsoft.Office.Interop.Excel
Assembly:  Microsoft.Office.Interop.Excel (in Microsoft.Office.Interop.Excel.dll)

Syntax

'Declaration
ReadOnly Property End ( _
    Direction As XlDirection _
) As Range
    Get
'Usage
Dim instance As Range
Dim Direction As XlDirection
Dim value As Range

value = instance.End(Direction)

Range this[
    XlDirection Direction
] { get; }

Parameters

• Direction
  Type: Microsoft.Office.Interop.Excel.XlDirection

  Required XlDirection. The direction in which to move.

Property Value

Type: Microsoft.Office.Interop.Excel.Range

Remarks

Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW.

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace