NamedRange Methods


Namespace:   Microsoft.Office.Tools.Excel
Assembly:  Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)


Activates a single-cell NamedRange control.


Adds a comment to the NamedRange control.

System_CAPS_pubmethodAdvancedFilter(XlFilterAction, Object, Object, Object)

Filters or copies data from a list based on a criteria range.


Performs a writeback operation for all edited cells in a named range based on an OLAP data source.

System_CAPS_pubmethodApplyNames(Object, Object, Object, Object, Object, XlApplyNamesOrder, Object)

Applies names to the cells in the NamedRange control.


Applies outlining styles to the NamedRange control.


Gets an AutoComplete match from the list.

System_CAPS_pubmethodAutoFill(Range, XlAutoFillType)

Automatically fills the cells in the NamedRange control.

System_CAPS_pubmethodAutoFilter(Object, Object, XlAutoFilterOperator, Object, Object)

Filters a list using the AutoFilter.


Changes the width of the columns or the height of the rows in the NamedRange control to achieve the best fit.


Automatically creates an outline for the NamedRange control.


(Inherited from ISupportInitialize.)

System_CAPS_pubmethodBorderAround2(Object, XlBorderWeight, XlColorIndex, Object, Object)

Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.


Calculates the values of cells in a NamedRange control.


Calculates a specific range of cells.

System_CAPS_pubmethodCheckSpelling(Object, Object, Object, Object)

Checks the spelling of text in the NamedRange control.


Clears the entire NamedRange control.


Clears all cell comments from the NamedRange control.


Clears the formulas from the NamedRange control.


Clears the formatting of the NamedRange control.


Removes all hyperlinks from the specified range.


Clears notes from all the cells in the NamedRange control.


Clears the outline for the NamedRange control.


Gets a Microsoft.Office.Interop.Excel.Range that represents all the cells whose contents are different from the comparison cell in each column.

System_CAPS_pubmethodConsolidate(Object, Object, Object, Object, Object)

Consolidates data from multiple ranges on multiple worksheets into the NamedRange control.


Copies the contents of the NamedRange control to the specified range or to the Clipboard.

System_CAPS_pubmethodCopyFromRecordset(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.

System_CAPS_pubmethodCopyPicture(XlPictureAppearance, XlCopyPictureFormat)

Copies the NamedRange control to the Clipboard as a picture.

System_CAPS_pubmethodCreateNames(Object, Object, Object, Object)

Creates names in the NamedRange control, based on text labels in the sheet.


Cuts the contents of the NamedRange control to the Clipboard or pastes it into a specified destination.

System_CAPS_pubmethodDataSeries(Object, XlDataSeriesType, XlDataSeriesDate, Object, Object, Object)

Creates a data series in the NamedRange control.


Deletes a dynamically created NamedRange control and removes it from the ControlCollection.


Displays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet.


Designates the NamedRange control to be recalculated when the next recalculation occurs.


Discards all changes in the edited cells of the range.


(Inherited from IDisposable.)

System_CAPS_pubmethodEditionOptions(XlEditionType, XlEditionOptionsOption, Object, Object, XlPictureAppearance, XlPictureAppearance, Object)

This API supports the product infrastructure and is not intended to be used directly from your code.


(Inherited from ISupportInitialize.)

System_CAPS_pubmethodExportAsFixedFormat(XlFixedFormatType, Object, Object, Object, Object, Object, Object, Object, Object)

Exports to a file of the specified format.


Fills down from the top cell or cells in the NamedRange control to the bottom of the NamedRange control.


Fills left from the rightmost cell or cells in the NamedRange control.


Fills right from the leftmost cell or cells in the NamedRange control.


Fills up from the bottom cell or cells in the NamedRange control to the top of the range.

System_CAPS_pubmethodFind(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.


Continues a search that was begun with the Find method.


Continues a search that was begun with the Find method.


Starts the Function Wizard for the upper-left cell of the NamedRange control.


Gets the value of the NamedRange control.


Gets an IEnumerator that can be used to iterate over the cells in the NamedRange control.

System_CAPS_pubmethodGroup(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.

System_CAPS_pubmethodInsert(Object, Object)

Inserts a cell or a range of cells into the NamedRange control and shifts other cells away to make space.


Adds an indent to the NamedRange control.


Rearranges the text in the NamedRange control so that it fills the range evenly.


Pastes a list of all displayed names onto the worksheet, beginning with the first cell in the NamedRange control.


Creates a merged cell from the NamedRange control.

System_CAPS_pubmethodNavigateArrow(Object, Object, Object)

Navigates a tracer arrow for the NamedRange control to the precedent, dependent, or error-causing cell or cells.

System_CAPS_pubmethodNoteText(Object, Object, Object)

Gets or sets the cell note associated with the cell in the upper-left corner of the NamedRange control.

System_CAPS_pubmethodParse(Object, Object)

Parses a range of data and breaks it into multiple cells.

System_CAPS_pubmethodPasteSpecial(XlPasteType, XlPasteSpecialOperation, Object, Object)

Pastes the contents of a Microsoft.Office.Interop.Excel.Range object from the Clipboard into the NamedRange control.

System_CAPS_pubmethodPrintOutEx(Object, Object, Object, Object, Object, Object, Object, Object)

Prints the object.


Shows a preview of the NamedRange control as it would look when printed.

System_CAPS_pubmethodRemoveDuplicates(Object, XlYesNoGuess)

Removes duplicate values from a range of values.


Removes subtotals from the NamedRange control.

System_CAPS_pubmethodReplace(Object, Object, Object, Object, Object, Object, Object, Object)

Replaces the specified characters in the NamedRange control with a new string.


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.


Selects the NamedRange control.

System_CAPS_pubmethodset_Value(Object, Object)

Sets the value of the NamedRange control.


Creates Phonetic objects for all the cells in the NamedRange control.


Scrolls through the contents of the active window to move the NamedRange control into view.


Draws tracer arrows to the direct dependents of the NamedRange control.


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.


Draws tracer arrows to the direct precedents of the NamedRange control.

System_CAPS_pubmethodSort(Object, XlSortOrder, Object, Object, XlSortOrder, Object, XlSortOrder, XlYesNoGuess, Object, Object, XlSortOrientation, XlSortMethod, XlSortDataOption, XlSortDataOption, XlSortDataOption)

Sorts the data in a NamedRange control.

System_CAPS_pubmethodSortSpecial(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.

System_CAPS_pubmethodSpeak(Object, Object)

Causes the cells of the NamedRange control to be spoken in row order or column order.

System_CAPS_pubmethodSpecialCells(XlCellType, Object)

Gets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that match the specified type and value.

System_CAPS_pubmethodSubscribeTo(String, XlSubscribeToFormat)

This API supports the product infrastructure and is not intended to be used directly from your code.

System_CAPS_pubmethodSubtotal(Int32, XlConsolidationFunction, Object, Object, Object, XlSummaryRow)

Creates subtotals for the NamedRange control.

System_CAPS_pubmethodTable(Object, Object)

Creates a data table based on input values and formulas that you define in a worksheet.

System_CAPS_pubmethodTextToColumns(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.


Promotes the NamedRange control in an outline (that is, decreases its outline level).


Separates a merged area into individual cells.

Return to top