The properties of the IRange interface are listed below. For a complete list of IRange interface members, see the IRange Members topic.
Borders | Returns an IBorders interface that represents the borders of the specified range. |
Characters | |
Column | Returns the number of the first column in the specified range |
Columns | Returns an IRangeColumns interface that represents the columns in the specified range. |
ColumnWidth | Gets or sets the width of columns in the specified range. |
Comment | Returns an IComment interface that represents the comment of the specified cell. |
Count | Returns the number of cells in the range. |
DisplayValue | Returns a formatted String representation of Value using NumberFormat |
EntireColumn | Returns an IRangeColumns interface that represents the entire column (or columns) that contains the specified range. |
EntireRow | Returns an IRangeRows interface that represents the entire row (or rows) that contains the specified range. |
Font | Returns an IFont interface that represents the font of the specified range |
Formula | Gets or sets the cell's formula. |
FormulaHidden | Gets or sets a value that indicates whether the formula in the range will be hidden when the worksheet is protected. |
HasFormula | Gets a value that indicates whether at least one cell in the range contains a formula. |
Height | Returns the height of the specified range. |
HorizontalAlignment | Gets or sets the horizontal alignment for the specified range. |
Hyperlinks | Returns an IHyperlinks interface that represents the collection of hyperlinks in the specified range. |
IndentLevel | Gets or sets the indent level for the cell or range. |
Interior | Returns an IInterior interface that represents the interior of the specified range. |
Item | Overloaded. Returns an IRange interface that represents a range at an offset to the specified range. |
Locked | Gets or sets a value that indicates whether the cell is locked. If the cell is not locked it can be modified when the sheet is protected. |
MergeArea | Returns an IRange interface 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 that indicates whether the specified range contains merged cells. |
NumberFormat | Gets or sets the format code for the specified range. |
Orientation | Gets or sets the text orientation for the specified range. |
OutlineLevel | Gets or sets the current outline level of the rows that contains the specified range. |
ReadingOrder | Gets or sets the reading order for the specified range. |
Row | Returns the number of the first row in the range. |
RowHeight | Gets or sets the height of rows in the specified range. |
Rows | Returns an IRangeRows interface that represents the rows in the specified range. |
ShrinkToFit | Determines if text automatically shrinks to fit in the available column width. |
Value | Gets or sets the value of the specified range. |
VerticalAlignment | Gets or sets the vertical alignment for the specified range. |
Width | Returns the width of the specified range. |
WrapText | Gets or sets a value that indicates whether the text are wrapped. |
IRange Interface | NativeExcel Namespace | Range Property | Cells Property | How to reference Cells and Ranges