The ExcelRange type exposes the following members.
Methods
| Name | Description | |
|---|---|---|
 | AddComment |
Adds the comment with the specified text to this range.
The range is expected to contain a single cell otherwise the comment will be placed on the top left cell of the range.
|
| AutofitColumns |
Changes the width of the range columns to achieve the best fit for the cells content.
|
| AutofitRows |
Changes the height of the range rows to achieve the best fit for the cells content.
|
| Clear |
Clears the range content and the cells formatting
|
| ClearContents |
Clears the range content but leaves the cells formatting
|
| Copy |
Copies this range to the specified destination range.
|
| Delete |
Deletes the cell in the range and shifts cells up to replace the deleted cells.
|
| Delete(ExcelDeleteShiftDirection) |
Deletes the cell in the range and shifts cells in the specified direction to replace the deleted cells.
|
| Equals | (Inherited from Object.) |
 | Finalize | Allows an object to try to free resources and perform other cleanup operations before it is reclaimed by garbage collection. (Inherited from Object.) |
| FreezePanes |
Freezes panes to keep row and column labels visible when the worksheet is scrolled.
To lock rows select the row below where you want the freeze to appear (e.g. The range "A5" will freeze the rows from 1 to 4).
To lock columns select the column to the right of where you want the split to appear (e.g. The range "D1" will freeze the columns A, B and C).
To lock both rows and columns select the cell below and to the right of where you want the split to appear
(e.g. The range "D5" will freeze the rows from 1 to 4 and the columns A, B and C).
|
| GetHashCode | Serves as a hash function for a particular type. (Inherited from Object.) |
| GetType | Gets the Type of the current instance. (Inherited from Object.) |
| Group(ExcelGroupBy) |
Groups the range by rows or columns function of the groupBy parameter.
|
| Group(ExcelGroupBy, Boolean) |
Groups the range by rows or columns function of the groupBy parameter.
|
| MemberwiseClone | Creates a shallow copy of the current Object. (Inherited from Object.) |
| Merge |
Merge the cells in this range in a merged area.
|
| Move |
Moves the range to the specified destination range.
|
| ToString | Returns a string that represents the current object. (Inherited from Object.) |
| UnGroup |
Ungroups the range.
|
| UnMerge |
Separates a merged range into individual cells.
|
See Also