Range Properties
Include Protected Members
Include Inherited Members
The Range type exposes the following members.
Properties
Name | Description | |
---|---|---|
_Default | Reserved for internal use. | |
AddIndent | Determines if text is automatically indented when the text alignment in a cell is set to equal distribution either horizontally or vertically. | |
Address | Returns the range reference. | |
AddressLocal | Returns the range reference for the specified range in the language of the user. | |
AllowEdit | Determines if the range can be edited on a protected worksheet. | |
Application | Returns an Application object that represents the Microsoft Excel application. | |
Areas | Returns an Areas collection that represents all the ranges in a multiple-area selection. | |
Borders | Returns a Borders collection that represents the borders of a style or a range of cells (including a range defined as part of a conditional format). | |
Cells | Returns a Range object that represents the cells in the specified range. | |
Characters | Returns a Characters object that represents a range of characters within the object text. | |
Column | Returns the number of the first column in the first area in the specified range. | |
Columns | Returns a Range object that represents the columns in the specified range. | |
ColumnWidth | Returns or sets the width of all columns in the specified range. | |
Comment | Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range. | |
Count | Returns the number of objects in the collection. | |
CountLarge | Counts the largest value in a given Range of values. Read-only. | |
Creator | Returns a 32-bit integer that indicates the application in which this object was created. | |
CurrentArray | If the specified cell is part of an array, returns a Range object that represents the entire array. | |
CurrentRegion | Returns a Range object that represents the current region. | |
Dependents | Returns a Range object that represents the range containing all the dependents of a cell. | |
DirectDependents | Returns a Range object that represents the range containing all the direct dependents of a cell. | |
DirectPrecedents | Returns a Range object that represents the range containing all the direct precedents of a cell. | |
DisplayFormat | Gets a DisplayFormat object that represents the display settings for the specified range. | |
End | Returns a Range object that represents the cell at the end of the region that contains the source range. | |
EntireColumn | Returns a Range object that represents the entire column (or columns) that contains the specified range. | |
EntireRow | Returns a Range object that represents the entire row (or rows) that contains the specified range. | |
Errors | Allows the user to access error checking options. | |
Font | Returns a Font object that represents the font of the specified object. | |
FormatConditions | Returns a FormatConditions collection that represents all the conditional formats for the specified range. | |
Formula | Returns or sets the object's formula in A1-style notation and in the language of the macro. | |
FormulaArray | Returns or sets the array formula of a range. | |
FormulaHidden | Determines if the formula will be hidden when the worksheet is protected. | |
FormulaLabel | Returns or sets the formula label type for the specified range. | |
FormulaLocal | Returns or sets the formula for the object, using A1-style references in the language of the user. | |
FormulaR1C1 | Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. | |
FormulaR1C1Local | Returns or sets the formula for the object, using R1C1-style notation in the language of the user. | |
HasArray | Determines if the specified cell is part of an array formula. | |
HasFormula | Determines if all cells in the range contain formulas. | |
Height | The height of the range. | |
Hidden | Determines if the rows or columns are hidden. | |
HorizontalAlignment | Returns or sets the horizontal alignment for the specified object. | |
Hyperlinks | Returns a Hyperlinks collection that represents the hyperlinks for the range. | |
ID | Returns or sets the identifying label for the specified cell when the page is saved as a Web page. | |
IndentLevel | Returns or sets the indent level for the cell or range. | |
Interior | Returns an Interior object that represents the interior of the specified object. | |
Item | Returns a Range object that represents a range at an offset to the specified range. | |
Left | The distance from the left edge of column A to the left edge of the range. | |
ListHeaderRows | Returns the number of header rows for the specified range. | |
ListObject | Returns a ListObject object for the Range object or QueryTable object. | |
LocationInTable | Returns a constant that describes the part of the PivotTable report that contains the upper-left corner of the specified range. | |
Locked | Determines if the object is locked. | |
MDX | Returns the MDX name for the specified Range object. Read-only. | |
MergeArea | Returns a Range object that represents the merged range containing the specified cell. | |
MergeCells | Determines if the range or style contains merged cells. | |
Name | Returns or sets the name of the object. | |
Next | Returns a Range object that represents the next cell. | |
NumberFormat | Returns or sets the format code for the object. | |
NumberFormatLocal | Returns or sets the format code for the object as a string in the language of the user. | |
Offset | Returns a Range object that represents a range that’s offset from the specified range. | |
Orientation | Returns the text orientation. | |
OutlineLevel | Returns or sets the current outline level of the specified row or column. | |
PageBreak | Returns or sets the location of a page break. | |
Parent | Returns the parent object for the specified object. | |
Phonetic | Returns the Phonetic object which contains information about a specific phonetic text string in a cell. | |
Phonetics | Returns the Phonetics collection of the range. | |
PivotCell | Returns a PivotCell object that represents a cell in a PivotTable report. | |
PivotField | Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range. | |
PivotItem | Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range. | |
PivotTable | Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range, or the PivotTable report associated with the PivotChart report. | |
Precedents | Returns a Range object that represents all the precedents of a cell. | |
PrefixCharacter | Returns the prefix character for the cell. | |
Previous | Returns a Range object that represents the previous cell. | |
QueryTable | Returns a QueryTable object that represents the query table that intersects the specified Range object. | |
Range | Returns a Range object that represents a cell or a range of cells. | |
ReadingOrder | Returns or sets the reading order for the specified object. | |
Resize | Resizes the specified range. | |
Row | Returns the number of the first row of the first area in the range. | |
RowHeight | Returns the height of all the rows in the range specified, measured in points. | |
Rows | Returns a Range object that represents the rows in the specified range. | |
ServerActions | Specifies the actions that can be performed on the SharePoint server for a Range object. | |
ShowDetail | Returns True if the outline is expanded for the specified range (so that the detail of the column or row is visible). | |
ShrinkToFit | Determines if text automatically shrinks to fit in the available column width. | |
SmartTags | Returns a SmartTags object representing the identifier for the specified cell. | |
SoundNote | This property should not be used. Sound notes have been removed from Microsoft Excel. | |
SparklineGroups | Gets a SparklineGroups object that represents an existing group of sparklines from the specified range. | |
Style | Returns a Style object that represents the style of the specified range. | |
Summary | Determines if the range is an outlining summary row or column. | |
Text | Returns or sets the text for the specified object. | |
Top | Returns the distance, in points, from the top edge of row 1 to the top edge of the range. | |
UseStandardHeight | Determines if the row height of the Range object equals the standard height of the sheet. | |
UseStandardWidth | Determines if the column width of the Range object equals the standard width of the sheet. | |
Validation | Returns the Validation object that represents data validation for the specified range. | |
Value | Returns or sets the value of the specified range. | |
Value2 | Returns or sets the cell value. | |
VerticalAlignment | Returns or sets the vertical alignment of the specified object. | |
Width | The width, in points, of the range. | |
Worksheet | Returns a Worksheet object that represents the worksheet containing the specified range. | |
WrapText | Determines if Microsoft Excel wraps the text in the object. | |
XPath | Returns an XPath object that represents the Xpath of the element mapped to the specified Range object. |
Top