NamedRange Methods
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
| Name | Description | |
|---|---|---|
 | Activate() | Activates a single-cell NamedRange control. |
| AddComment(Object^) | Adds a comment to the NamedRange control. |
| AdvancedFilter(XlFilterAction, Object^, Object^, Object^) | Filters or copies data from a list based on a criteria range. |
| AllocateChanges() | Performs a writeback operation for all edited cells in a named range based on an OLAP data source. |
| ApplyNames(Object^, Object^, Object^, Object^, Object^, XlApplyNamesOrder, Object^) | Applies names to the cells in the NamedRange control. |
| ApplyOutlineStyles() | Applies outlining styles to the NamedRange control. |
| AutoComplete(String^) | Gets an AutoComplete match from the list. |
| AutoFill(Range^, XlAutoFillType) | Automatically fills the cells in the NamedRange control. |
| AutoFilter(Object^, Object^, XlAutoFilterOperator, Object^, Object^) | Filters a list using the AutoFilter. |
| AutoFit() | Changes the width of the columns or the height of the rows in the NamedRange control to achieve the best fit. |
| AutoOutline() | Automatically creates an outline for the NamedRange control. |
| BeginInit() | (Inherited from ISupportInitialize.) |
| BorderAround2(Object^, XlBorderWeight, XlColorIndex, Object^, Object^) | Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border. |
| Calculate() | Calculates the values of cells in a NamedRange control. |
| CalculateRowMajorOrder() | Calculates a specific range of cells. |
| CheckSpelling(Object^, Object^, Object^, Object^) | Checks the spelling of text in the NamedRange control. |
| Clear() | Clears the entire NamedRange control. |
| ClearComments() | Clears all cell comments from the NamedRange control. |
| ClearContents() | Clears the formulas from the NamedRange control. |
| ClearFormats() | Clears the formatting of the NamedRange control. |
| ClearHyperlinks() | Removes all hyperlinks from the specified range. |
| ClearNotes() | Clears notes from all the cells in the NamedRange control. |
| ClearOutline() | Clears the outline for the NamedRange control. |
| ColumnDifferences(Object^) | Gets a Microsoft.Office.Interop.Excel::Range that represents all the cells whose contents are different from the comparison cell in each column. |
| Consolidate(Object^, Object^, Object^, Object^, Object^) | Consolidates data from multiple ranges on multiple worksheets into the NamedRange control. |
| Copy(Object^) | Copies the contents of the NamedRange control to the specified range or to the Clipboard. |
| CopyFromRecordset(Object^, Object^, Object^) | Copies the contents of an ADO or DAO recordset into a worksheet, beginning at the upper-left corner of the NamedRange control. |
| CopyPicture(XlPictureAppearance, XlCopyPictureFormat) | Copies the NamedRange control to the Clipboard as a picture. |
| CreateNames(Object^, Object^, Object^, Object^) | Creates names in the NamedRange control, based on text labels in the sheet. |
| Cut(Object^) | Cuts the contents of the NamedRange control to the Clipboard or pastes it into a specified destination. |
| DataSeries(Object^, XlDataSeriesType, XlDataSeriesDate, Object^, Object^, Object^) | Creates a data series in the NamedRange control. |
| Delete() | Deletes a dynamically created NamedRange control and removes it from the ControlCollection. |
| DialogBox() | Displays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet. |
| Dirty() | Designates the NamedRange control to be recalculated when the next recalculation occurs. |
| DiscardChanges() | Discards all changes in the edited cells of the range. |
| Dispose() | (Inherited from IDisposable.) |
| EditionOptions(XlEditionType, XlEditionOptionsOption, Object^, Object^, XlPictureAppearance, XlPictureAppearance, Object^) | This API supports the product infrastructure and is not intended to be used directly from your code. |
| EndInit() | (Inherited from ISupportInitialize.) |
| ExportAsFixedFormat(XlFixedFormatType, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Exports to a file of the specified format. |
| FillDown() | Fills down from the top cell or cells in the NamedRange control to the bottom of the NamedRange control. |
| FillLeft() | Fills left from the rightmost cell or cells in the NamedRange control. |
| FillRight() | Fills right from the leftmost cell or cells in the NamedRange control. |
| FillUp() | Fills up from the bottom cell or cells in the NamedRange control to the top of the range. |
| Find(Object^, Object^, Object^, Object^, Object^, XlSearchDirection, Object^, Object^, Object^) | Finds specific information in the NamedRange control, and returns a Microsoft.Office.Interop.Excel::Range object that represents the first cell where that information is found. |
| FindNext(Object^) | Continues a search that was begun with the Find method. |
| FindPrevious(Object^) | Continues a search that was begun with the Find method. |
| FunctionWizard() | Starts the Function Wizard for the upper-left cell of the NamedRange control. |
| get_Value(Object^) | Gets the value of the NamedRange control. |
| GetEnumerator() | Gets an IEnumerator that can be used to iterate over the cells in the NamedRange control. |
| Group(Object^, Object^, Object^, Object^) | When the NamedRange control represents a single cell in a PivotTable field’s data range, the Group method performs numeric or date-based grouping in that field. |
| Insert(Object^, Object^) | Inserts a cell or a range of cells into the NamedRange control and shifts other cells away to make space. |
| InsertIndent(Int32) | Adds an indent to the NamedRange control. |
| Justify() | Rearranges the text in the NamedRange control 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 NamedRange control. |
| Merge(Object^) | Creates a merged cell from the NamedRange control. |
| NavigateArrow(Object^, Object^, Object^) | Navigates a tracer arrow for the NamedRange control to the precedent, dependent, or error-causing cell or cells. |
| NoteText(Object^, Object^, Object^) | Gets or sets the cell note associated with the cell in the upper-left corner of the NamedRange control. |
| Parse(Object^, Object^) | Parses a range of data and breaks it into multiple cells. |
| PasteSpecial(XlPasteType, XlPasteSpecialOperation, Object^, Object^) | Pastes the contents of a Microsoft.Office.Interop.Excel::Range object from the Clipboard into the NamedRange control. |
| PrintOutEx(Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Prints the object. |
| PrintPreview(Object^) | Shows a preview of the NamedRange control as it would look when printed. |
| RemoveDuplicates(Object^, XlYesNoGuess) | Removes duplicate values from a range of values. |
| RemoveSubtotal() | Removes subtotals from the NamedRange control. |
| Replace(Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Replaces the specified characters in the NamedRange control with a new string. |
| RowDifferences(Object^) | Gets a Microsoft.Office.Interop.Excel::Range object that represents all the cells whose contents are different from those of the comparison cell in each row. |
| Select() | Selects the NamedRange control. |
| set_Value(Object^, Object^) | Sets the value of the NamedRange control. |
| SetPhonetic() | Creates Phonetic objects for all the cells in the NamedRange control. |
| Show() | Scrolls through the contents of the active window to move the NamedRange control into view. |
| ShowDependents(Object^) | Draws tracer arrows to the direct dependents of the NamedRange control. |
| ShowErrors() | Draws tracer arrows through the precedents tree to the cell that is the source of the error, and returns the Microsoft.Office.Interop.Excel::Range object that contains that cell. |
| ShowPrecedents(Object^) | Draws tracer arrows to the direct precedents of the NamedRange control. |
| Sort(Object^, XlSortOrder, Object^, Object^, XlSortOrder, Object^, XlSortOrder, XlYesNoGuess, Object^, Object^, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption) | Sorts the data in a NamedRange control. |
| SortSpecial(XlSortMethod, Object^, XlSortOrder, Object^, Object^, XlSortOrder, Object^, XlSortOrder, XlYesNoGuess, Object^, Object^, XlSortOrientation, XlSortDataOption, XlSortDataOption, XlSortDataOption) | Uses East Asian sorting methods to sort the NamedRange control. For example, Japanese sorts in the order of the Kana syllabary. For more information, see the parameters list. |
| Speak(Object^, Object^) | Causes the cells of the NamedRange control to be spoken in row order or column order. |
| SpecialCells(XlCellType, Object^) | Gets a Microsoft.Office.Interop.Excel::Range object that represents all the cells that match the specified type and value. |
| SubscribeTo(String^, XlSubscribeToFormat) | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Subtotal(Int32, XlConsolidationFunction, Object^, Object^, Object^, XlSummaryRow) | Creates subtotals for the NamedRange control. |
| Table(Object^, Object^) | Creates a data table based on input values and formulas that you define in a worksheet. |
| TextToColumns(Object^, XlTextParsingType, XlTextQualifier, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^, Object^) | Parses a column of cells that contain text into several columns. |
| Ungroup() | Promotes the NamedRange control in an outline (that is, decreases its outline level). |
| UnMerge() | Separates a merged area into individual cells. |