| Name | Description | |
|---|---|---|
 | AllowEdit | Gets a value indicating whether the range can be edited on a protected worksheet. |
| Areas | Gets an IAreas collection that represents all the ranges in a multiple-area selection. |
| Borders | Gets the IBorders object that represents the borders of the specified object. |
| Cells | Gets a IRange object that represents the cells in the specified range. |
| Column | Gets the zero based column number of the first column of this Range. |
| Column2 | Gets the zero based column number of the last column of this Range. |
| ColumnCount | Gets the number of columns in this Range. |
| Columns | Gets a new instance of IRange which represents all columns belong to this IRange. |
| ColumnWidth | Gets or sets the width of the column. |
| Count | Get an integer value that represents the number of cells in the range. |
| CurrentArray | Gets an IRange object that represents the entire array if the specified cell is part of an array. |
| Dependents | Returns a Range object that represents the range containing all the dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DirectDependents | Returns a Range object that represents the range containing all the direct dependents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DirectPrecedents | Returns a Range object that represents the range containing all the direct precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one dependent. |
| DisplayFormat | Gets a DisplayFormat object that represents the display settings for the specified range. |
| EntireColumn | Gets a IRange object that represents the entire column (or columns) that contains the specified range. |
| EntireRow | Gets a IRange object that represents the entire row (or rows) that contains the specified range. |
| Font | Gets the IFont object that represents the font of the specified object. |
| FormatConditions | Gets all format conditions of this IRange. |
| FormattedValue | Gets or sets the cell value(s). |
| Formula | Gets or sets the formula, which will implicitly intersect as required when set, for this IRange. |
| Formula2 | Gets or sets the formula for this IRange. |
| Formula2R1C1 | Gets or sets the formula using R1C1-style notation for this IRange. |
| FormulaArray | Gets or sets the array formula for this IRange. |
| FormulaR1C1 | Gets or sets the formula using R1C1-style notation which will implicitly intersect as required when set, for this IRange. |
| HasArray | Gets a value indicating whether the specified cell is part of an array formula. |
| HasFormula | Gets a value indicating whether all cells in the range contain formulas. |
| Hidden | Gets or sets a value indicating whether this IRange is hidden. |
| HorizontalAlignment | Gets or sets the horizontal alignment. |
| IndentLevel | Gets or sets the indent level. |
| Interior | Gets the IInterior object that represents the interior of the specified object. |
| Item | Overloaded. Gets the IRange with the specified reference. |
| Locked | Gets or sets a value indicating whether this IRange is locked. |
| MergeArea | Returns a Range object that represents the merged range containing the specified cell. If the specified cell isn't in a merged range, this property returns the specified cell. |
| MergeCells | Gets or sets a value indicating whether this range contains merged cells. |
| NumberFormat | Gets or sets the number format of current cell. |
| Orientation | Gets or sets the text orientation. |
| OutlineLevel | Gets or sets the current outline level of the specified row or column. |
| PageBreak | Gets or sets the location of a page break. |
| Precedents | Returns a Range object that represents all the precedents of a cell. This can be a multiple selection (a union of Range objects) if there's more than one precedent. |
| Row | Gets the zero based row number of the first row of this Range. |
| Row2 | Gets the zero based row number of the last row of this Range. |
| RowCount | Gets the number of rows in this Range. |
| RowHeight | Gets or sets the height of the row. |
| Rows | Gets a new instance of IRange which represents all rows belong to this IRange. |
| ShowDetail | true if the outline is expanded for the specified range (so that the detail of the column or row is visible). The specified range must be a single summary column or row in an outline. |
| ShrinkToFit | Gets or sets a value indicating whether text automatically shrinks to fit in the available column width. |
| Style | Gets or sets the style for the cell. |
| Summary | Gets a value indicating whether the range is an outlining summary row or column. |
| Text | Gets or sets the text for the cell. |
| Validation | Gets an instance of IValidation which may be used to get and set validation properties of the cells represented by this IRange. |
| Value | Gets or sets the cell value. |
| VerticalAlignment | Gets or sets the vertical alignment. |
| Worksheet | Gets a Worksheet object that represents the worksheet containing the specified range. |
| WrapText | Gets or sets a value indicating whether Spread wraps the text in the object. |
The following tables list the members exposed by IRange.
Public Properties
Public Methods
| Name | Description | |
|---|---|---|
 | Activate | Activates a single cell, which must be inside the current selection. |
| Address | Overloaded. Returns a System.String value that represents the range reference. |
| ApplyNumberFormat | Applies the number format to the range. |
| ApplyStyle | Overloaded. Applies the named style to the range. |
| AutoFilter | Overloaded. Creates the automatic filter for current selection if the filter doesn't exist; otherwise, remove the filter. |
| AutoFit | Changes the width of the columns or the height of the rows in the range to achieve the best fit. |
| Calculate | Calculates this range of cells on a worksheet. |
| Clear | Removes all the data and formulas from the specified range of cells. |
| Copy | Overloaded. Copies the data from a range of cells to a specified range of cells. |
| CreateTable | Creates the ITable at the specified cell range. |
| GoalSeek | Overloaded. Calculates the values necessary to achieve a specific goal. |
| Group | Demotes a range in an outline (that is, increases its outline level). The specified range must be a row or column, or a range of rows or columns. |
| Merge | Creates a merged cell from the specified IRange object. |
| Move | Overloaded. Moves the data from a range of cells to the specified location. |
| Offset | Returns a IRange object that represents a translated range from the specified range. |
| Range | Get an IRange object that represents a cell or a range of cells. |
| Select | Select a cell or a range of cells. |
| Ungroup | Promotes a range in an outline (that is, decreases its outline level). The specified range must be a row or column, or a range of rows or columns. |
| UnMerge | Separates a merged area into individual cells. |
See Also