This documentation is archived and is not being maintained.

Range Properties 

  Name Description
_Default  
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.
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.
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.
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.
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.
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.
Show: