For a list of all members of this type, see IRange members.
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. |
![]() | 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. |
![]() | 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. |
![]() | Insert | Overloaded. |
![]() | 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. |
![]() | Select | Sets the current selection of the worksheet associated the this IRange to this cells in this IRange. |
![]() | UnMerge | Converts merged cells in the represented range to normal cells. |