For a list of all members of this type, see IRange members.
Public Methods
| Name | Description | |
|---|---|---|
 | Activate | Sets the active cell of the worksheet associated with this IRange to the top-left cell of this IRange. |
| AddComment | Adds a single comment with the specified text to the single cell represented by this range. |
| AutoFit | Automatically sets the width of the specified columns or the height of the specified rows. |
| Clear | Clears formulas, values and all formatting from the current IRange. |
| ClearComments | Clears all comments associated with any cells in this range. |
| ClearContents | Clears formulas and values from the current IRange. |
| ClearFormats | Clears all formatting from the current IRange. |
| ClearOutline | Clears the specified represented row or column outline levels, or all outline levels of the associated worksheet if this range does not represent rows or columns. |
| Copy | Overloaded. |
| CopyDown | Copies values, formulas and formats in the top row of the range to subsequent rows. |
| CopyFromDataTable | Copies the specified DataTable to this range. |
| CopyRight | Copies values, formulas and formats in the left column of the range to subsequent columns. |
| Delete | Overloaded. |
| Find | Searches for the specified text according to the specified options, and returns an IRange representing the found cell or null if no cell is found. |
| GetAddress | Returns a string representing the address of the range. |
| GetArea | Returns the zero based instance of IRange specified by index. |
| GetCharacters | Returns an instance of ICharacters which represents a range of characters belonging to a text cell. |
| GetDataSet | Returns a newly created data set from the cells referred to by this IRange. |
| GetDataTable | Returns a newly created data table from the cells referred to by this IRange. |
| Group | Increments the OutlineLevel of the specified rows or columns. |
| Insert | Overloaded. |
| Intersect | Returns a new range which consists of the intersection of this range and range2, or null if the ranges do not intersect. |
| Merge | Merges the cells in the represented range into a single merged cell. |
| Offset | Returns a copy of the current IRange which is offset by the specified number of rows and columns. |
| Replace | Attempts to replace the specified text according to the specified options, returning the number of replacements if successful or zero if not successful. |
| Select | Sets the current selection of the worksheet associated with the this range to the cells in this range. |
| Sort | Sorts the cells represented by this range according to the specified options. |
| Subtract | Returns a new range which consists of this range with range2 removed, or null if the resulting range is empty. |
| Ungroup | Decrements the OutlineLevel of the specified rows or columns. |
| Union | Returns a new range which consists of the union of this range and range2. |
| UnMerge | Converts merged cells in the represented range to normal cells. |