Range Members
Include Protected Members
Include Inherited Members
Represents a cell, a row, a column, a selection of cells containing one or more contiguous blocks of cells, or a 3-D range.
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
Methods
Name | Description | |
---|---|---|
![]() |
_PasteSpecial | Reserved for internal use. |
![]() |
_PrintOut | Reserved for internal use. |
![]() |
Activate | Activates a single cell, which must be inside the current selection. |
![]() |
AddComment | Adds a comment to the range. |
![]() |
AdvancedFilter | Filters or copies data from a list based on a criteria range. |
![]() |
AllocateChanges | Performs a writeback operation for all edited cells in a range based on an OLAP data source. |
![]() |
ApplyNames | Applies names to the cells in the specified range. |
![]() |
ApplyOutlineStyles | Applies outlining styles to the specified range. |
![]() |
AutoComplete | Returns an AutoComplete match from the list. |
![]() |
AutoFill | Performs an autofill on the cells in the specified range. |
![]() |
AutoFilter | Filters a list using the AutoFilter. |
![]() |
AutoFit | Changes the width of the columns in the range or the height of the rows in the range to achieve the best fit. |
![]() |
AutoFormat | Automatically formats the specified range, using a predefined format. |
![]() |
AutoOutline | Automatically creates an outline for the specified range. |
![]() |
BorderAround | Adds a border to a range and sets the Color, LineStyle, and Weight properties for the new border. |
![]() |
BorderAround2 | Reserved for internal use. |
![]() |
Calculate | Calculates a specified range of cells on a worksheet. |
![]() |
CalculateRowMajorOrder | Calculates a specfied range of cells. |
![]() |
CheckSpelling | Checks the spelling of an object. |
![]() |
Clear | Clears the entire object. |
![]() |
ClearComments | Clears all cell comments from the specified range. |
![]() |
ClearContents | Clears the formulas from the range. |
![]() |
ClearFormats | Clears the formatting of the object. |
![]() |
ClearHyperlinks | Removes all hyperlinks from the specified range. |
![]() |
ClearNotes | Clears notes and sound notes from all the cells in the specified range. |
![]() |
ClearOutline | Clears the outline for the specified range. |
![]() |
ColumnDifferences | Returns a Range object that represents all the cells whose contents are different from the comparison cell in each column. |
![]() |
Consolidate | Consolidates data from multiple ranges on multiple worksheets into a single range on a single worksheet. |
![]() |
Copy | Copies the range to the specified range or to the Clipboard. |
![]() |
CopyFromRecordset | Copies the contents of an ADO or DAO Recordset object onto a worksheet, beginning at the upper-left corner of the specified range. |
![]() |
CopyPicture | Copies the selected object to the Clipboard as a picture. |
![]() |
CreateNames | Creates names in the specified range, based on text labels in the sheet. |
![]() |
CreatePublisher | You have requested Help for a keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. |
![]() |
Cut | Cuts the object to the Clipboard or pastes it into a specified destination. |
![]() |
DataSeries | Creates a data series in the specified range. |
![]() |
Delete | Deletes the object. |
![]() |
DialogBox | Displays a dialog box defined by a dialog box definition table on a Microsoft Excel 4.0 macro sheet. |
![]() |
Dirty | Designates a range to be recalculated when the next recalculation occurs. |
![]() |
DiscardChanges | Discards all changes in the edited cells of the range. |
![]() |
EditionOptions | You have requested Help for a keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. |
![]() |
ExportAsFixedFormat | Exports to a file of the specified format. |
![]() |
FillDown | Fills down from the top cell or cells in the specified range to the bottom of the range. |
![]() |
FillLeft | Fills left from the rightmost cell or cells in the specified range. |
![]() |
FillRight | Fills right from the leftmost cell or cells in the specified range. |
![]() |
FillUp | Fills up from the bottom cell or cells in the specified range to the top of the range. |
![]() |
Find | Finds specific information in a range and returns a Range object that represents the first cell where that information is found. |
![]() |
FindNext | Continues a search that was begun with the Find method. |
![]() |
FindPrevious | Continues a search that was begun with the Find method. |
![]() |
FunctionWizard | Starts the Function Wizard for the upper-left cell of the range. |
![]() |
GetEnumerator() | (Inherited from IEnumerable.) |
![]() |
GetEnumerator() | |
![]() |
GoalSeek | Calculates the values necessary to achieve a specific goal. |
![]() |
Group | When the Range object represents a single cell in a PivotTable field’s data range, the Group method performs numeric or date-based grouping in that field. |
![]() |
Insert | Inserts a cell or a range of cells into the worksheet or macro sheet and shifts other cells away to make space. |
![]() |
InsertIndent | Adds an indent to the specified range. |
![]() |
Justify | Rearranges the text in a range so that it fills the range evenly. |
![]() |
ListNames | Pastes a list of all displayed names onto the worksheet, beginning with the first cell in the range. |
![]() |
Merge | Creates a merged cell from the specified Range object. |
![]() |
NavigateArrow | Navigates a tracer arrow for the specified range to the precedent, dependent, or error-causing cell or cells. |
![]() |
NoteText | Returns or sets the cell note associated with the cell in the upper-left corner of the range. |
![]() |
Parse | Parses a range of data and breaks it into multiple cells. |
![]() |
PasteSpecial | Pastes a Range from the Clipboard into the specified range. |
![]() |
PrintOut | Prints the object. |
![]() |
PrintOutEx | Reserved for internal use. |
![]() |
PrintPreview | Shows a preview of the object as it would look when printed. |
![]() |
RemoveDuplicates | Removes duplicate values from a range of values. |
![]() |
RemoveSubtotal | Removes subtotals from a list. |
![]() |
Replace | Returns a Boolean indicating characters in cells within the specified range. |
![]() |
RowDifferences | Returns a Range object that represents all the cells whose contents are different from those of the comparison cell in each row. |
![]() |
Run | Runs the Microsoft Excel macro at this location. |
![]() |
Select | Selects the object. |
![]() |
SetPhonetic | Creates Phonetic objects for all the cells in the specified range. |
![]() |
Show | Scrolls through the contents of the active window to move the range into view. |
![]() |
ShowDependents | Draws tracer arrows to the direct dependents of the range. |
![]() |
ShowErrors | Draws tracer arrows through the precedents tree to the cell that’s the source of the error and returns the range that contains that cell. |
![]() |
ShowPrecedents | Draws tracer arrows to the direct precedents of the range. |
![]() |
Sort | Sorts a PivotTable report, a range, or the active region if the specified range contains only one cell. |
![]() |
SortSpecial | Uses East Asian sorting methods to sort the range or a PivotTable report, or uses the method for the active region if the range contains only one cell. For example, Japanese sorts in the order of the Kana syllabary. |
![]() |
Speak | Causes the cells of the range to be spoken in row order or column order. |
![]() |
SpecialCells | Returns a Range object that represents all the cells that match the specified type and value. |
![]() |
SubscribeTo | You have requested Help for a keyword used only on the Macintosh. For information about this keyword, consult the language reference Help included with Microsoft Office Macintosh Edition. |
![]() |
Subtotal | Creates subtotals for the range (or the current region, if the range is a single cell). |
![]() |
Table | Creates a data table based on input values and formulas that you define on a worksheet. |
![]() |
TextToColumns | Parses a column of cells that contain text into several columns. |
![]() |
Ungroup | Promotes a range in an outline (that is, decreases its outline level). |
![]() |
UnMerge | Separates a merged area into individual cells. |
Top