The methods of the IRange interface are listed below. For a complete list of IRange interface members, see the IRange Members topic.
AddComment | Overloaded. Adds a comment to the cell and returns IComment interface. |
Address | Overloaded. Returns the range reference. |
Autofit | Changes the width of the columns in the range to achieve the best fit. |
Clear | Clears the cells in the specified range. |
ClearComments | Clears all cell comments from the specified range. |
ClearContents | Clears the data from the range but leaves the formatting. |
ClearOutline | Clears the outline for rows and columns in the specified range. |
Copy | Overloaded. Copies a cell or a range of cells to the specified range. |
Delete | Overloaded. Deletes a cell or a range of cells from the worksheet. |
GetDataTable | Returns a newly created data table from the specified range. |
GetEnumerator | Returns an System.Collections.IEnumerator implemented object that contains all cells within the range. |
Group | Increases the outline level of rows in the specifed range. |
Insert | Overloaded. Inserts a cell or a range of cells into the worksheet and shifts other cells away to make space. |
isIntersect | Tests whether the range is intersected with specified range. |
Merge | Overloaded. Creates a merged cell from the specified range. |
Move | Overloaded. Moves a cell or a range of cells to the specified range. |
SaveAs | Overloaded. Saves range content in a file or a Stream. |
Select | Selects the cells in the specified range. |
SetDataTable | Copies the specified DataTable into this range. |
Ungroup | Decreases the outline level of rows in the specifed range. |
UnMerge | Separates a merged area into individual cells. |
IRange Interface | NativeExcel Namespace | Range Property | Cells Property | How to reference Cells and Ranges