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