Share via

Range.Offset Property

  • Article

Returns a Range object that represents a range that’s offset from the specified range.

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

Syntax

'Declaration
ReadOnly Property Offset ( _
    RowOffset As Object, _
    ColumnOffset As Object _
) As Range
    Get
'Usage
Dim instance As Range
Dim RowOffset As Object
Dim ColumnOffset As Object
Dim value As Range

value = instance.Offset(RowOffset, ColumnOffset)

Range this[
    Object RowOffset,
    Object ColumnOffset
] { get; }

Parameters

  • RowOffset
    Type: System.Object

    Optional Object. The number of rows (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset downward, and negative values are offset upward. The default value is 0.

  • ColumnOffset
    Type: System.Object

    Optional Object. The number of columns (positive, negative, or 0 (zero)) by which the range is to be offset. Positive values are offset to the right, and negative values are offset to the left. The default value is 0.

Property Value

Type: Microsoft.Office.Interop.Excel.Range

See Also

Reference

Range Interface

Range Members

Microsoft.Office.Interop.Excel Namespace