Range Properties (Excel)
Contribute to this content Use GitHub to suggest and submit changes. See our guidelines for contributing to VBA documentation. |
Properties
Name |
Description |
---|---|
Returns or sets a Variant value that indicates if text is automatically indented when the text alignment in a cell is set to equal distribution (either horizontally or vertically.) |
|
Returns a String value that represents the range reference in the language of the macro. |
|
Returns the range reference for the specified range in the language of the user. Read-only String. |
|
Returns a Boolean value that indicates if the range can be edited on a protected worksheet. |
|
When used without an object qualifier, this property returns an Application object that represents the Microsoft Excel application. When used with an object qualifier, this property returns an Application object that represents the creator of the specified object (you can use this property with an OLE Automation object to return the application of that object). Read-only. |
|
Returns an Areas collection that represents all the ranges in a multiple-area selection. Read-only. |
|
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). |
|
Returns a Range object that represents the cells in the specified range. |
|
Returns a Characters object that represents a range of characters within the object text. You can use the Characters object to format characters within a text string. |
|
Returns the number of the first column in the first area in the specified range. Read-only Long. |
|
Returns a Range object that represents the columns in the specified range. |
|
Returns or sets the width of all columns in the specified range. Read/write Variant. |
|
Returns a Comment object that represents the comment associated with the cell in the upper-left corner of the range. |
|
Returns a Long value that represents the number of objects in the collection. |
|
Returns a value that represents the number of objects in the collection. Read-only Variant. |
|
Returns a 32-bit integer that indicates the application in which this object was created. Read-only Long. |
|
If the specified cell is part of an array, returns a Range object that represents the entire array. Read-only. |
|
Returns a Range object that represents the current region. The current region is a range bounded by any combination of blank rows and blank columns. Read-only. |
|
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. Read-only Range object. |
|
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. Read-only Range object. |
|
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 precedent. Read-only Range object. |
|
Returns a DisplayFormat object that represents the display settings for the specified range. Read-only |
|
Returns a Range object that represents the cell at the end of the region that contains the source range. Equivalent to pressing END+UP ARROW, END+DOWN ARROW, END+LEFT ARROW, or END+RIGHT ARROW. Read-only Range object. |
|
Returns a Range object that represents the entire column (or columns) that contains the specified range. Read-only. |
|
Returns a Range object that represents the entire row (or rows) that contains the specified range. Read-only. |
|
Allows the user to to access error checking options. |
|
Returns a Font object that represents the font of the specified object. |
|
Returns a FormatConditions collection that represents all the conditional formats for the specified range. Read-only. |
|
Returns or sets a Variant value that represents the object's formula in A1-style notation and in the macro language. |
|
Returns or sets the array formula of a range. Returns (or can be set to) a single formula or a Visual Basic array. If the specified range doesn't contain an array formula, this property returns null. Read/write Variant. |
|
Returns or sets a Variant value that indicates if the formula will be hidden when the worksheet is protected. |
|
Returns or sets the formula for the object, using A1-style references in the language of the user. Read/write Variant. |
|
Returns or sets the formula for the object, using R1C1-style notation in the language of the macro. Read/write Variant. |
|
Returns or sets the formula for the object, using R1C1-style notation in the language of the user. Read/write Variant. |
|
True if the specified cell is part of an array formula. Read-only Variant. |
|
True if all cells in the range contain formulas; False if none of the cells in the range contains a formula; null otherwise. Read-only Variant. |
|
Returns or sets a Variant value that represents the height, in points, of the range. |
|
Returns or sets a Variant value that indicates if the rows or columns are hidden. |
|
Returns or sets a Variant value that represents the horizontal alignment for the specified object. |
|
Returns a Hyperlinks collection that represents the hyperlinks for the range. |
|
Returns or sets a String value that represents the identifying label for the specified cell when the page is saved as a Web page. |
|
Returns or sets a Variant value that represents the indent level for the cell or range. Can be an integer from 0 to 15. |
|
Returns an Interior object that represents the interior of the specified object. |
|
Returns a Range object that represents a range at an offset to the specified range. |
|
Returns a Variant value that represents the distance, in points, from the left edge of column A to the left edge of the range. |
|
Returns the number of header rows for the specified range. Read-only Long. |
|
Returns a ListObject object for the Range object. Read-only ListObject object. |
|
Returns a constant that describes the part of the PivotTable report that contains the upper-left corner of the specified range. Can be one of the following XlLocationInTable. constants. Read-only Long. |
|
Returns or sets a Variant value that indicates if the object is locked. |
|
Returns the MDX name for the specified Range object. Read-only String. |
|
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. Read-only Variant. |
|
True if the range contains merged cells. Read/write Variant. |
|
Returns or sets a Variant value that represents the name of the object. |
|
Returns a Range object that represents the next cell. |
|
Returns or sets a Variant value that represents the format code for the object. |
|
Returns or sets a Variant value that represents the format code for the object as a string in the language of the user. |
|
Returns a Range object that represents a range that’s offset from the specified range. |
|
Returns or sets a Variant value that represents the text orientation. |
|
Returns or sets the current outline level of the specified row or column. Read/write Variant. |
|
Returns or sets the location of a page break. Can be one of the following XlPageBreak constants: xlPageBreakAutomatic, xlPageBreakManual, or xlPageBreakNone. Read/write Long. |
|
Returns the parent object for the specified object. Read-only. |
|
Returns the Phonetic object, which contains information about a specific phonetic text string in a cell. |
|
Returns the Phonetics collection of the range. Read only. |
|
Returns a PivotCell object that represents a cell in a PivotTable report. |
|
Returns a PivotField object that represents the PivotTable field containing the upper-left corner of the specified range. |
|
Returns a PivotItem object that represents the PivotTable item containing the upper-left corner of the specified range. |
|
Returns a PivotTable object that represents the PivotTable report containing the upper-left corner of the specified range. |
|
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. Read-only. |
|
Returns the prefix character for the cell. Read-only Variant. |
|
Returns a Range object that represents the next cell. |
|
Returns a QueryTable object that represents the query table that intersects the specified Range object. |
|
Returns a Range object that represents a cell or a range of cells. |
|
Returns or sets the reading order for the specified object. Can be one of the following constants: xlRTL (right-to-left), xlLTR (left-to-right), or xlContext. Read/write Long. |
|
Resizes the specified range. Returns a Range object that represents the resized range. |
|
Returns the number of the first row of the first area in the range. Read-only Long. |
|
Returns or sets the height of the first row in the range specified, measured in points. Read/write Variant. |
|
Returns a Range object that represents the rows in the specified range. Read-only Range object. |
|
Specifies the actions that can be performed on the SharePoint server for a Range object. |
|
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. Read/write Variant. For the PivotItem object (or the Range object if the range is in a PivotTable report), this property is set to True if the item is showing detail. |
|
Returns or sets a Variant value that indicates if text automatically shrinks to fit in the available column width. |
|
This property should not be used. Sound notes have been removed from Microsoft Excel. |
|
Returns a SparklineGroups object that represents an existing group of sparklines from the specified range. Read-only |
|
Returns or sets a Variant value, containing a Style object, that represents the style of the specified range. |
|
True if the range is an outlining summary row or column. The range should be a row or a column. Read-only Variant. |
|
Returns or sets the text for the specified object. Read-only String. |
|
Returns a Variant value that represents the distance, in points, from the top edge of row 1 to the top edge of the range. |
|
True if the row height of the Range object equals the standard height of the sheet. Returns Null if the range contains more than one row and the rows aren’t all the same height. Read/write Variant. |
|
True if the column width of the Range object equals the standard width of the sheet. Returns null if the range contains more than one column and the columns aren’t all the same width. Read/write Variant. |
|
Returns the Validation object that represents data validation for the specified range. Read-only. |
|
Returns or sets a Variant value that represents the value of the specified range. |
|
Returns or sets the cell value. Read/write Variant. |
|
Returns or sets a Variant value that represents the vertical alignment of the specified object. |
|
Returns a Variant value that represents the width, in units, of the range. |
|
Returns a Worksheet object that represents the worksheet containing the specified range. Read-only. |
|
Returns or sets a Variant value that indicates if Microsoft Excel wraps the text in the object. |
|
Returns an XPath object that represents the Xpath of the element mapped to the specified Range object. The context of the range determines whether or not the action succeeds or returns an empty object. Read-only. |