NamedRange Methods

 

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

NameDescription
System_CAPS_pubmethodActivate()

Activates a single-cell NamedRange control.

System_CAPS_pubmethodAddComment(Object)

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.

System_CAPS_pubmethodAllocateChanges()

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.

System_CAPS_pubmethodApplyOutlineStyles()

Applies outlining styles to the NamedRange control.

System_CAPS_pubmethodAutoComplete(String)

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.

System_CAPS_pubmethodAutoFit()

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

System_CAPS_pubmethodAutoOutline()

Automatically creates an outline for the NamedRange control.

System_CAPS_pubmethodBeginInit()

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

System_CAPS_pubmethodCalculate()

Calculates the values of cells in a NamedRange control.

System_CAPS_pubmethodCalculateRowMajorOrder()

Calculates a specific range of cells.

System_CAPS_pubmethodCheckSpelling(Object, Object, Object, Object)

Checks the spelling of text in the NamedRange control.

System_CAPS_pubmethodClear()

Clears the entire NamedRange control.

System_CAPS_pubmethodClearComments()

Clears all cell comments from the NamedRange control.

System_CAPS_pubmethodClearContents()

Clears the formulas from the NamedRange control.

System_CAPS_pubmethodClearFormats()

Clears the formatting of the NamedRange control.

System_CAPS_pubmethodClearHyperlinks()

Removes all hyperlinks from the specified range.

System_CAPS_pubmethodClearNotes()

Clears notes from all the cells in the NamedRange control.

System_CAPS_pubmethodClearOutline()

Clears the outline for the NamedRange control.

System_CAPS_pubmethodColumnDifferences(Object)

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.

System_CAPS_pubmethodCopy(Object)

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.

System_CAPS_pubmethodCut(Object)

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.

System_CAPS_pubmethodDelete()

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

System_CAPS_pubmethodDialogBox()

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

System_CAPS_pubmethodDirty()

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

System_CAPS_pubmethodDiscardChanges()

Discards all changes in the edited cells of the range.

System_CAPS_pubmethodDispose()

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

System_CAPS_pubmethodEndInit()

(Inherited from ISupportInitialize.)

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

Exports to a file of the specified format.

System_CAPS_pubmethodFillDown()

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

System_CAPS_pubmethodFillLeft()

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

System_CAPS_pubmethodFillRight()

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

System_CAPS_pubmethodFillUp()

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.

System_CAPS_pubmethodFindNext(Object)

Continues a search that was begun with the Find method.

System_CAPS_pubmethodFindPrevious(Object)

Continues a search that was begun with the Find method.

System_CAPS_pubmethodFunctionWizard()

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

System_CAPS_pubmethodget_Value(Object)

Gets the value of the NamedRange control.

System_CAPS_pubmethodGetEnumerator()

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.

System_CAPS_pubmethodInsertIndent(Int32)

Adds an indent to the NamedRange control.

System_CAPS_pubmethodJustify()

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

System_CAPS_pubmethodListNames()

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

System_CAPS_pubmethodMerge(Object)

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.

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

System_CAPS_pubmethodRemoveSubtotal()

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.

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

System_CAPS_pubmethodSelect()

Selects the NamedRange control.

System_CAPS_pubmethodset_Value(Object, Object)

Sets the value of the NamedRange control.

System_CAPS_pubmethodSetPhonetic()

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

System_CAPS_pubmethodShow()

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

System_CAPS_pubmethodShowDependents(Object)

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

System_CAPS_pubmethodShowErrors()

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.

System_CAPS_pubmethodShowPrecedents(Object)

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.

System_CAPS_pubmethodUngroup()

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

System_CAPS_pubmethodUnMerge()

Separates a merged area into individual cells.

Return to top
Show: