Export (0) Print
Expand All

NamedRange Interface

[This documentation is for preview only, and is subject to change in later releases. Blank topics are included as placeholders.]

A NamedRange control is a range that has a unique name, exposes events, and can be bound to data.

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

[GuidAttribute("6b87f7cb-0689-4e7e-8dcb-3c0e654629bb")]
public interface NamedRange : IBindableComponent, 
	IComponent, IDisposable, ISupportInitialize

The NamedRange type exposes the following members.

  NameDescription
Public propertyAddIndentGets or sets a value that determines whether text is automatically indented when the text alignment in the NamedRange control is set to equal distribution either horizontally or vertically.
Public propertyAddressGets the range reference for the NamedRange control.
Public propertyAddressLocalGets the range reference for the NamedRange control in the language of the user.
Public propertyAllowEditGets a value that indicates whether the NamedRange control can be edited on a protected worksheet.
Public propertyApplicationGets a Microsoft.Office.Interop.Excel.Application that represents the creator of the NamedRange control.
Public propertyAreasGets an Areas collection that represents all the ranges in a multiple-area selection.
Public propertyBindingContextGets or sets the collection of currency managers for the IBindableComponent. (Inherited from IBindableComponent.)
Public propertyBordersGets a Borders collection that represents the borders of the NamedRange control.
Public propertyCellsGets a Microsoft.Office.Interop.Excel.Range that represents the cells in the NamedRange control.
Public propertyCharactersGets a Microsoft.Office.Interop.Excel.Characters object that represents a range of characters within the text of the NamedRange control.
Public propertyColumnGets the number of the first column in the first area of the NamedRange control.
Public propertyColumnsGets a Microsoft.Office.Interop.Excel.Range that represents the one or more columns in the NamedRange control.
Public propertyColumnWidthGets or sets the width of all columns in the NamedRange control.
Public propertyCommentGets a Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control.
Public propertyContainerInfrastructure.
Public propertyCountGets the number of cells in the NamedRange control.
Public propertyCountLargeGets the number of occurrences of the largest value in a range of values.
Public propertyCreatorGets a 32-bit integer that indicates the application in which the NamedRange control was created.
Public propertyCurrentArrayIf the NamedRange control is part of an array, gets a Microsoft.Office.Interop.Excel.Range that represents the entire array.
Public propertyCurrentRegionGets a Microsoft.Office.Interop.Excel.Range that represents the current region.
Public propertyDataBindingsGets the collection of data-binding objects for this IBindableComponent. (Inherited from IBindableComponent.)
Public propertyDefaultDataSourceUpdateModeGets or sets the default DataSourceUpdateMode.
Public propertyDependentsGets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the dependents of the NamedRange control.
Public propertyDirectDependentsGets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the direct dependents of the NamedRange control.
Public propertyDirectPrecedentsGets a Microsoft.Office.Interop.Excel.Range that represents the range containing all the direct precedents of the NamedRange control.
Public propertyDisplayFormatGets an object that represents the display settings for the specified range.
Public propertyEndGets a Microsoft.Office.Interop.Excel.Range that represents the cell at the end of the region that contains the NamedRange control.
Public propertyEntireColumnGets a Microsoft.Office.Interop.Excel.Range that represents the entire column (or columns) that contains the NamedRange control.
Public propertyEntireRowGets a Microsoft.Office.Interop.Excel.Range that represents the entire row (or rows) that contains the NamedRange control.
Public propertyErrorsGets an Errors object that enables you to access error checking options.
Public propertyFontGets a Font that represents the font of the NamedRange control.
Public propertyFormatConditionsGets a FormatConditions collection that represents all the conditional formats for the NamedRange control.
Public propertyFormulaGets or sets the NamedRange control's formula in A1-style notation.
Public propertyFormulaArrayGets or sets the array formula of the NamedRange control.
Public propertyFormulaHiddenGets or sets a value that indicates whether the formula in the NamedRange control will be hidden when the worksheet is protected.
Public propertyFormulaLabelGets or sets the formula label type for the NamedRange control.
Public propertyFormulaLocalGets or sets the formula for the NamedRange control, using A1-style references in the language of the user.
Public propertyFormulaR1C1Gets or sets the formula for the object, using R1C1-style notation.
Public propertyFormulaR1C1LocalGets or sets the formula for the NamedRange control, using R1C1-style notation in the language of the user.
Public propertyHasArrayGets a value that indicates whether the NamedRange control is part of an array formula.
Public propertyHasFormulaGets a value that indicates whether all cells in the NamedRange control contain formulas.
Public propertyHeightGets the height of the NamedRange control.
Public propertyHiddenGets or sets an object that indicates whether the rows or columns are hidden.
Public propertyHorizontalAlignmentGets or sets the horizontal alignment for the NamedRange control.
Public propertyHyperlinksGets a Hyperlinks collection that represents the hyperlinks in the NamedRange control.
Public propertyIDGets or sets the identifying label for the NamedRange control when the page is saved as a Web page.
Public propertyIndentLevelGets or sets the indent level for the NamedRange control.
Public propertyInnerObjectGets a Microsoft.Office.Interop.Excel.Range that represents the underlying native object for the Microsoft.Office.Tools.Excel.NamedRange.
Public propertyInteriorGets an Interior that represents the interior of the NamedRange control.
Public propertyItemGets a Microsoft.Office.Interop.Excel.Range that represents a range at an offset to the NamedRange control.
Public propertyLeftGets the distance from the left edge of column A to the left edge of the NamedRange control.
Public propertyListHeaderRowsGets the number of header rows for the NamedRange control.
Public propertyListObjectGets a Microsoft.Office.Interop.Excel.ListObject for the NamedRange control.
Public propertyLocationInTableGets a constant that describes the part of the PivotTable report that contains the upper-left corner of the NamedRange control.
Public propertyLockedGets or sets a value that indicates whether the NamedRange control is locked.
Public propertyMDXGets the MDX name for the specified NamedRange object.
Public propertyMergeAreaGets a Microsoft.Office.Interop.Excel.Range that represents the merged range containing the NamedRange control.
Public propertyMergeCellsGets or sets a value that indicates whether the NamedRange control contains merged cells.
Public propertyNameGets or sets a Name object for the NamedRange control.
Public propertyNextGets a Microsoft.Office.Interop.Excel.Range that represents the next cell.
Public propertyNumberFormatGets or sets the format code for the NamedRange control.
Public propertyNumberFormatLocalGets or sets the format code for the NamedRange control in the language of the user.
Public propertyOffsetGets a Microsoft.Office.Interop.Excel.Range that is offset from the NamedRange control.
Public propertyOrientationGets or sets the text orientation.
Public propertyOutlineLevelGets or sets the current outline level of the NamedRange control.
Public propertyPageBreakGets or sets the location of a page break.
Public propertyParentGets the parent object of the NamedRange control.
Public propertyPhoneticGets the Phonetic object, which contains information about a specific phonetic text string in the NamedRange control.
Public propertyPhoneticsGets the Phonetics collection of the NamedRange control.
Public propertyPivotCellGets a PivotCell that represents a cell in a PivotTable report.
Public propertyPivotFieldGets a PivotField that represents the PivotTable field containing the upper left corner of the NamedRange control.
Public propertyPivotItemGets a PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control.
Public propertyPivotTableGets a PivotTable that represents the PivotTable report containing the upper left corner of the NamedRange control, or the PivotTable report associated with the PivotChart report.
Public propertyPrecedentsGets a Microsoft.Office.Interop.Excel.Range that represents all the precedents of the NamedRange control.
Public propertyPrefixCharacterGets the prefix character for the NamedRange control.
Public propertyPreviousGets a Microsoft.Office.Interop.Excel.Range that represents the previous cell.
Public propertyQueryTableGets a QueryTable that represents the query table that intersects the NamedRange control.
Public propertyReadingOrderGets or sets the reading order for the NamedRange control.
Public propertyRefersToGets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation.
Public propertyRefersToLocalGets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation in the language of the user.
Public propertyRefersToR1C1Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation.
Public propertyRefersToR1C1LocalGets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation in the language of the user.
Public propertyRefersToRangeGets the Microsoft.Office.Interop.Excel.Range referred to by a NamedRange control.
Public propertyResizeGets a resized Microsoft.Office.Interop.Excel.Range based on the NamedRange control.
Public propertyRowGets the number of the first row of the first area in the NamedRange control.
Public propertyRowHeightGets or sets the height of all the rows in the NamedRange control, measured in points.
Public propertyRowsGets a Microsoft.Office.Interop.Excel.Range that represents one or more rows in the NamedRange control.
Public propertyServerActionsGets the actions that can be performed on the Microsoft Office SharePoint server for a NamedRange object.
Public propertyShowDetailGets or sets an object that indicates whether the outline is expanded for the NamedRange control (so that the detail of the column or row is visible).
Public propertyShrinkToFitGets or sets a value that indicates whether text automatically shrinks to fit in the available column width.
Public propertySiteGets or sets the ISite associated with the IComponent. (Inherited from IComponent.)
Public propertySmartTagsGets a SmartTags object that represents the identifier for the NamedRange control. This type or member is intended to be used only in projects for the 2007 Microsoft Office system. Smart tags are deprecated in Office 2010.
.
Public propertySoundNoteInfrastructure.
Public propertySparklineGroupsGets an object that represents an existing group of sparklines from the specified range.
Public propertyStyleGets or sets a Style that represents the style of the NamedRange control.
Public propertySummaryGets a value that indicates whether the range is an outlining summary row or column.
Public propertyTagGets or sets the object that contains data about the Tag control.
Public propertyTextGets the text for the NamedRange control.
Public propertyTopGets the distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control.
Public propertyUseStandardHeightGets or sets a value that indicates whether the row height of the NamedRange control equals the standard height of the sheet.
Public propertyUseStandardWidthGets or sets a value that indicates whether the column width of the NamedRange control equals the standard width of the sheet.
Public propertyValidationGets a Validation object that represents data validation for the NamedRange control.
Public propertyValueGets or sets the value of the NamedRange control.
Public propertyValue2Gets or sets the value of the NamedRange control.
Public propertyVerticalAlignmentGets or sets the vertical alignment of the NamedRange control.
Public propertyWidthGets the width of the NamedRange control in points.
Public propertyWorksheetGets a Microsoft.Office.Interop.Excel.Worksheet that represents the worksheet that contains the NamedRange control.
Public propertyWrapTextGets or sets a value that indicates whether Microsoft Office Excel wraps the text in the NamedRange control.
Public propertyXPathGets an XPath that represents the Xpath of the element mapped to the NamedRange control.
Top

  NameDescription
Public method_PasteSpecialInfrastructure.
Public method_PrintOutInfrastructure.
Public methodActivateActivates a single-cell NamedRange control.
Public methodAddCommentAdds a comment to the NamedRange control.
Public methodAdvancedFilterFilters or copies data from a list based on a criteria range.
Public methodAllocateChangesPerforms a writeback operation for all edited cells in a named range based on an OLAP data source.
Public methodApplyNamesApplies names to the cells in the NamedRange control.
Public methodApplyOutlineStylesApplies outlining styles to the NamedRange control.
Public methodAutoCompleteGets an AutoComplete match from the list.
Public methodAutoFillAutomatically fills the cells in the NamedRange control.
Public methodAutoFilterFilters a list using the AutoFilter.
Public methodAutoFitChanges the width of the columns or the height of the rows in the NamedRange control to achieve the best fit.
Public methodAutoFormatAutomatically formats the NamedRange control, using a predefined format.
Public methodAutoOutlineAutomatically creates an outline for the NamedRange control.
Public methodBeginInitSignals the object that initialization is starting. (Inherited from ISupportInitialize.)
Public methodBorderAroundAdds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public methodBorderAround2Adds a border to a NamedRange control and sets the Color, LineStyle, and Weight properties for the new border.
Public methodCalculateCalculates the values of cells in a NamedRange control.
Public methodCalculateRowMajorOrderCalculates a specific range of cells.
Public methodCheckSpellingChecks the spelling of text in the NamedRange control.
Public methodClearClears the entire NamedRange control.
Public methodClearCommentsClears all cell comments from the NamedRange control.
Public methodClearContentsClears the formulas from the NamedRange control.
Public methodClearFormatsClears the formatting of the NamedRange control.
Public methodClearHyperlinksRemoves all hyperlinks from the specified range.
Public methodClearNotesClears notes from all the cells in the NamedRange control.
Public methodClearOutlineClears the outline for the NamedRange control.
Public methodColumnDifferencesGets a Microsoft.Office.Interop.Excel.Range that represents all the cells whose contents are different from the comparison cell in each column.
Public methodConsolidateConsolidates data from multiple ranges on multiple worksheets into the NamedRange control.
Public methodCopyCopies the contents of the NamedRange control to the specified range or to the Clipboard.
Public methodCopyFromRecordsetCopies the contents of an ADO or DAO recordset into a worksheet, beginning at the upper-left corner of the NamedRange control.
Public methodCopyPictureCopies the NamedRange control to the Clipboard as a picture.
Public methodCreateNamesCreates names in the NamedRange control, based on text labels in the sheet.
Public methodCreatePublisherInfrastructure.
Public methodCutCuts the contents of the NamedRange control to the Clipboard or pastes it into a specified destination.
Public methodDataSeriesCreates a data series in the NamedRange control.
Public methodDeleteDeletes a dynamically created NamedRange control and removes it from the ControlCollection.
Public methodDialogBoxDisplays a dialog box defined by a dialog box definition table on a Microsoft Office Excel 4.0 macro sheet.
Public methodDirtyDesignates the NamedRange control to be recalculated when the next recalculation occurs.
Public methodDiscardChangesDiscards all changes in the edited cells of the range.
Public methodDisposePerforms application-defined tasks associated with freeing, releasing, or resetting unmanaged resources. (Inherited from IDisposable.)
Public methodEditionOptionsInfrastructure.
Public methodEndInitSignals the object that initialization is complete. (Inherited from ISupportInitialize.)
Public methodExportAsFixedFormatExports to a file of the specified format.
Public methodFillDownFills down from the top cell or cells in the NamedRange control to the bottom of the NamedRange control.
Public methodFillLeftFills left from the rightmost cell or cells in the NamedRange control.
Public methodFillRightFills right from the leftmost cell or cells in the NamedRange control.
Public methodFillUpFills up from the bottom cell or cells in the NamedRange control to the top of the range.
Public methodFindFinds 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.
Public methodFindNextContinues a search that was begun with the Find method.
Public methodFindPreviousContinues a search that was begun with the Find method.
Public methodFunctionWizardStarts the Function Wizard for the upper-left cell of the NamedRange control.
Public methodget_AddressInfrastructure. Use the Address property instead of this method.
Public methodget_AddressLocalInfrastructure. Use the AddressLocal property instead of this method.
Public methodget_CharactersInfrastructure. Use the Characters property instead of this method.
Public methodget_EndInfrastructure. Use the End property instead of this method.
Public methodget_ItemInfrastructure. Use the Item property instead of this method.
Public methodget_OffsetInfrastructure. Use the Offset property instead of this method.
Public methodget_RangeInfrastructure.
Public methodget_ResizeInfrastructure. Use the Resize property instead of this method.
Public methodget_ValueGets the value of the NamedRange control.
Public methodGetEnumeratorGets an IEnumerator that can be used to iterate over the cells in the NamedRange control.
Public methodGoalSeekCalculates the values necessary to achieve a specific goal.
Public methodGroupWhen 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.
Public methodInsertInserts a cell or a range of cells into the NamedRange control and shifts other cells away to make space.
Public methodInsertIndentAdds an indent to the NamedRange control.
Public methodJustifyRearranges the text in the NamedRange control so that it fills the range evenly.
Public methodListNamesPastes a list of all displayed names onto the worksheet, beginning with the first cell in the NamedRange control.
Public methodMergeCreates a merged cell from the NamedRange control.
Public methodNavigateArrowNavigates a tracer arrow for the NamedRange control to the precedent, dependent, or error-causing cell or cells.
Public methodNoteTextGets or sets the cell note associated with the cell in the upper-left corner of the NamedRange control.
Public methodParseParses a range of data and breaks it into multiple cells.
Public methodPasteSpecialPastes the contents of a Microsoft.Office.Interop.Excel.Range object from the Clipboard into the NamedRange control.
Public methodPrintOutPrints the NamedRange control.
Public methodPrintOutExPrints the object.
Public methodPrintPreviewShows a preview of the NamedRange control as it would look when printed.
Public methodRemoveDuplicatesRemoves duplicate values from a range of values.
Public methodRemoveSubtotalRemoves subtotals from the NamedRange control.
Public methodReplaceReplaces the specified characters in the NamedRange control with a new string.
Public methodRowDifferencesGets 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.
Public methodRunInfrastructure.
Public methodSelectSelects the NamedRange control.
Public methodset_ItemInfrastructure. Use the Item property instead of this method.
Public methodset_ValueSets the value of the NamedRange control.
Public methodSetPhoneticCreates Phonetic objects for all the cells in the NamedRange control.
Public methodShowScrolls through the contents of the active window to move the NamedRange control into view.
Public methodShowDependentsDraws tracer arrows to the direct dependents of the NamedRange control.
Public methodShowErrorsDraws 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.
Public methodShowPrecedentsDraws tracer arrows to the direct precedents of the NamedRange control.
Public methodSortSorts the data in a NamedRange control.
Public methodSortSpecialUses 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.
Public methodSpeakCauses the cells of the NamedRange control to be spoken in row order or column order.
Public methodSpecialCellsGets a Microsoft.Office.Interop.Excel.Range object that represents all the cells that match the specified type and value.
Public methodSubscribeToInfrastructure.
Public methodSubtotalCreates subtotals for the NamedRange control.
Public methodTableCreates a data table based on input values and formulas that you define in a worksheet.
Public methodTextToColumnsParses a column of cells that contain text into several columns.
Public methodUngroupPromotes the NamedRange control in an outline (that is, decreases its outline level).
Public methodUnMergeSeparates a merged area into individual cells.
Top

  NameDescription
Public eventBeforeDoubleClickOccurs when a NamedRange control is double-clicked, before the default double-click action.
Public eventBeforeRightClickOccurs when a NamedRange control is right-clicked, before the default right-click action.
Public eventBindingContextChangedInfrastructure.
Public eventChangeOccurs when something changes in the NamedRange control.
Public eventDeselectedOccurs when selection moves from the NamedRange control to an area outside of the NamedRange control.
Public eventDisposedRepresents the method that handles the Disposed event of a component. (Inherited from IComponent.)
Public eventSelectedOccurs when the NamedRange control is selected.
Public eventSelectionChangeOccurs when the selection inside the NamedRange control changes.
Top

For more information, see NamedRange Control.

NoteNote

This interface is implemented by the Visual Studio Tools for Office runtime. It is not intended to be implemented in your code. For more information, see Visual Studio Tools for Office Runtime Overview.

Usage

This documentation describes the version of this type that is used in Office projects that target the .NET Framework 4 and the .NET Framework 4.5. In projects that target the .NET Framework 3.5, this type might have different members and the code examples provided for this type might not work. For documentation about this type in projects that target the .NET Framework 3.5, see the following reference section in the Visual Studio 2008 documentation: http://go.microsoft.com/fwlink/?LinkId=160658.

Show:
© 2014 Microsoft