Spread Windows Forms 14.0
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / IRange Interface / Offset Method
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.
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.


In This Topic
    Offset Method (IRange)
    In This Topic
    Returns a IRange object that represents a translated range from the specified range.
    Syntax
    'Declaration
     
    
    Function Offset( _
       Optional ByVal rowOffset As Integer, _
       Optional ByVal columnOffset As Integer _
    ) As IRange
    'Usage
     
    
    Dim instance As IRange
    Dim rowOffset As Integer
    Dim columnOffset As Integer
    Dim value As IRange
     
    value = instance.Offset(rowOffset, columnOffset)

    Parameters

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

    Return Value

    IRange.
    See Also