Range Methods
Office 2003
| Name | Description | |
|---|---|---|
 | _PasteSpecial | |
| | _PrintOut | |
| | 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. |
| | 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. |
| | Calculate | Calculates a specified range of cells on a worksheet. |
| | 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. |
| | 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. |
| | 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. |
| | 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 | Returns an enumerator to support iterating through the collection. |
| | 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. |
| | PrintPreview | Shows a preview of the object as it would look when printed. |
| | 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. |
