Offset Method

Returns a copy of the current IRange which is offset by the specified number of rows and columns.

[Visual Basic]
Overridable Function Offset( _
   ByVal rowOffset As Integer, _
   ByVal columnOffset As Integer _
) As IRange

[C#]
virtual IRange Offset( 
   int rowOffset,
   int columnOffset
);

[C++]
virtual IRange* Offset( 
   int rowOffset,
   int columnOffset
) 

[C++/CLI]
virtual IRange^ Offset( 
   int rowOffset,
   int columnOffset
) 

Parameters

rowOffset

The number of rows to offset by (may be negative).

columnOffset

The number of columns to offset by (may be negative).

Return Type

A copy of the current IRange which is offset by the specified number of rows and columns.

Requirements

Platforms: Windows 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family

See Also

IRange Interface  | IRange Members  | Intersect Method  | Subtract Method  | Union Method

See our live Excel Reporting, Excel Charting, Excel to DataGrid and Excel Calculation Samples.

Copyright © 2003-2007 SpreadsheetGear LLC. All Rights Reserved.

SpreadsheetGear and Spreadsheet Gear are trademarks of SpreadsheetGear LLC.