NamedRange Members (2007 System)
Include Protected Members
Include Inherited Members
A NamedRange control is a range that has a unique name, exposes events, and can be bound to data. For more information, see NamedRange Control.
The NamedRange type exposes the following members.
Constructors
Name
Description
.gif "Public method")
Infrastructure. Overloaded.
Top
Methods
Name
Description
Infrastructure.
Infrastructure.
Activates a single-cell NamedRange control.
Adds a comment to the NamedRange control.
Filters or copies data from a list based on a criteria range.
Applies names to the cells in the NamedRange control.
Applies outlining styles to the NamedRange control.
Gets an AutoComplete match from the list.
Automatically fills the cells in the NamedRange control.
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 formats the NamedRange control, using a predefined format.
Automatically creates an outline for the NamedRange control.
Infrastructure.
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.
Checks the spelling of text in the NamedRange control.
.gif "Protected method")
(Inherited from RemoteComponent.)
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.
Clears notes from all the cells in the NamedRange control.
Clears the outline for the NamedRange control.
Gets a Range that represents all the cells whose contents are different from the comparison cell in each column.
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.
Copies the contents of an ADO or DAO recordset into a worksheet, beginning at the upper-left corner of the NamedRange control.
Copies the NamedRange control to the Clipboard as a picture.
Creates names in the NamedRange control, based on text labels in the sheet.
Infrastructure.
Cuts the contents of the NamedRange control to the Clipboard or pastes it into a specified destination.
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.
Overloaded.
Infrastructure.
Infrastructure.
Determines whether the specified Object is equal to the current Object. (Inherited from 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.
(Inherited from RemoteComponent.)
Finds specific information in the NamedRange control, and returns a 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.
Infrastructure. Use the Address property instead of this method.
Infrastructure. Use the AddressLocal property instead of this method.
Infrastructure. Use the Characters property instead of this method.
Infrastructure. Use the End property instead of this method.
Infrastructure. Use the Item property instead of this method.
Infrastructure. Use the Offset property instead of this method.
Infrastructure.
Infrastructure. Use the Resize property instead of this method.
Gets the value of the NamedRange control.
Gets an IEnumerator that can be used to iterate over the cells in the NamedRange control.
Serves as a hash function for a particular type. (Inherited from Object.)
(Inherited from RemoteComponent.)
(Inherited from RemoteComponent.)
Gets the type of the current instance. (Inherited from Object.)
Calculates the values necessary to achieve a specific goal.
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.
(Inherited from RemoteComponent.)
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 shallow copy of the current Object. (Inherited from Object.)
Creates a merged cell from the NamedRange control.
Navigates a tracer arrow for the NamedRange control to the precedent, dependent, or error-causing cell or cells.
Gets or sets the cell note associated with the cell in the upper-left corner of the NamedRange control.
Infrastructure. (Inherited from RemoteBindableComponent.)
Parses a range of data and breaks it into multiple cells.
Pastes the contents of a Range object from the Clipboard into the NamedRange control.
Prints the NamedRange control.
Prints the object.
Shows a preview of the NamedRange control as it would look when printed.
Removes duplicate values from a range of values.
Removes subtotals from the NamedRange control.
Replaces the specified characters in the NamedRange control with a new string.
Gets a Range object that represents all the cells whose contents are different from those of the comparison cell in each row.
Infrastructure.
Selects the NamedRange control.
Infrastructure. Use the Item property instead of this method.
Sets the value of the NamedRange control.
Creates Phonetic objects for all the cells in the NamedRange control.
(Inherited from RemoteComponent.)
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 Range object that contains that cell.
Draws tracer arrows to the direct precedents of the NamedRange control.
Sorts the data in a NamedRange control.
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.
Causes the cells of the NamedRange control to be spoken in row order or column order.
Gets a Range object that represents all the cells that match the specified type and value.
Infrastructure.
Creates subtotals for the NamedRange control.
Creates a data table based on input values and formulas that you define in a worksheet.
Parses a column of cells that contain text into several columns.
Returns a string that represents the current object. (Inherited from Object.)
Promotes the NamedRange control in an outline (that is, decreases its outline level).
Separates a merged area into individual cells.
Top
Properties
Name
Description
.gif "Public property")
Gets 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.
Gets the range reference for the NamedRange control.
Gets the range reference for the NamedRange control in the language of the user.
Gets a value that indicates whether the NamedRange control can be edited on a protected worksheet.
Gets a Application that represents the creator of the NamedRange control.
Gets an Areas collection that represents all the ranges in a multiple-area selection.
Gets or sets the System.Windows.Forms.BindingContext for the component. (Inherited from RemoteBindableComponent.)
Gets a Borders collection that represents the borders of the NamedRange control.
Gets a Range that represents the cells in the NamedRange control.
Gets a Characters object that represents a range of characters within the text of the NamedRange control.
Gets the number of the first column in the first area of the NamedRange control.
Gets a Range that represents the one or more columns in the NamedRange control.
Gets or sets the width of all columns in the NamedRange control.
Gets a Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control.
(Inherited from RemoteComponent.)
Infrastructure. (Inherited from RemoteBindableComponent.)
Gets the number of cells in the NamedRange control.
Gets the number of occurrences of the largest value in a range of values.
Gets a 32-bit integer that indicates the application in which the NamedRange control was created.
If the NamedRange control is part of an array, gets a Range that represents the entire array.
Gets a Range that represents the current region.
Gets the Binding objects for the component. (Inherited from RemoteBindableComponent.)
Gets or sets the default DataSourceUpdateMode for the component. (Inherited from RemoteBindableComponent.)
Gets a Range that represents the range containing all the dependents of the NamedRange control.
.gif "Protected property")
(Inherited from RemoteComponent.)
Gets a Range that represents the range containing all the direct dependents of the NamedRange control.
Gets a Range that represents the range containing all the direct precedents of the NamedRange control.
Gets a Range that represents the cell at the end of the region that contains the NamedRange control.
Gets a Range that represents the entire column (or columns) that contains the NamedRange control.
Gets a Range that represents the entire row (or rows) that contains the NamedRange control.
Gets an Errors object that enables you to access error checking options.
Gets a Font that represents the font of the NamedRange control.
Gets a FormatConditions collection that represents all the conditional formats for the NamedRange control.
Gets or sets the NamedRange control's formula in A1-style notation.
Gets or sets the array formula of the NamedRange control.
Gets or sets a value that indicates whether the formula in the NamedRange control will be hidden when the worksheet is protected.
Gets or sets the formula label type for the NamedRange control.
Gets or sets the formula for the NamedRange control, using A1-style references in the language of the user.
Gets or sets the formula for the object, using R1C1-style notation.
Gets or sets the formula for the NamedRange control, using R1C1-style notation in the language of the user.
Gets a value that indicates whether the NamedRange control is part of an array formula.
Gets a value that indicates whether all cells in the NamedRange control contain formulas.
Gets the height of the NamedRange control.
Gets or sets an object that indicates whether the rows or columns are hidden.
Gets or sets the horizontal alignment for the NamedRange control.
(Inherited from RemoteComponent.)
Gets a Hyperlinks collection that represents the hyperlinks in the NamedRange control.
Gets or sets the identifying label for the NamedRange control when the page is saved as a Web page.
(Inherited from RemoteComponent.)
Gets or sets the indent level for the NamedRange control.
Gets a Range that represents the underlying native object for the Microsoft.Office.Tools.Excel.NamedRange.
(Inherited from RemoteComponent.)
Gets an Interior that represents the interior of the NamedRange control.
Gets a Range that represents a range at an offset to the NamedRange control.
(Inherited from RemoteComponent.)
Gets the distance from the left edge of column A to the left edge of the NamedRange control.
Gets the number of header rows for the NamedRange control.
Gets a ListObject for the NamedRange control.
Gets a constant that describes the part of the PivotTable report that contains the upper-left corner of the NamedRange control.
Gets or sets a value that indicates whether the NamedRange control is locked.
Gets the MDX name for the specified NamedRange object.
Gets a Range that represents the merged range containing the NamedRange control.
Gets or sets a value that indicates whether the NamedRange control contains merged cells.
Gets or sets a Name object for the NamedRange control.
Gets a Range that represents the next cell.
Gets or sets the format code for the NamedRange control.
Gets or sets the format code for the NamedRange control in the language of the user.
Gets a Range that is offset from the NamedRange control.
Gets or sets the text orientation.
Gets or sets the current outline level of the NamedRange control.
Gets or sets the location of a page break.
Gets the parent object of the NamedRange control.
Gets the Phonetic object, which contains information about a specific phonetic text string in the NamedRange control.
Gets the Phonetics collection of the NamedRange control.
Gets a PivotCell that represents a cell in a PivotTable report.
Gets a PivotField that represents the PivotTable field containing the upper left corner of the NamedRange control.
Gets a PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control.
Gets 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.
Gets a Range that represents all the precedents of the NamedRange control.
Gets the prefix character for the NamedRange control.
Gets a Range that represents the previous cell.
(Inherited from RemoteComponent.)
Gets a QueryTable that represents the query table that intersects the NamedRange control.
Gets or sets the reading order for the NamedRange control.
Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation.
Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation in the language of the user.
Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation.
Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation in the language of the user.
Gets the Range referred to by a NamedRange control.
Gets a resized Range based on the NamedRange control.
Gets the number of the first row of the first area in the NamedRange control.
Gets or sets the height of all the rows in the NamedRange control, measured in points.
Gets a Range that represents one or more rows in the NamedRange control.
Gets the actions that can be performed on the Microsoft Office SharePoint server for a NamedRange object.
Gets 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).
Gets or sets a value that indicates whether text automatically shrinks to fit in the available column width.
(Inherited from RemoteComponent.)
Gets a SmartTags object that represents the identifier for the NamedRange control.
Infrastructure.
Gets or sets a Style that represents the style of the NamedRange control.
Gets a value that indicates whether the range is an outlining summary row or column.
(Inherited from RemoteComponent.)
Gets the text for the NamedRange control.
Gets the distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control.
Gets or sets a value that indicates whether the row height of the NamedRange control equals the standard height of the sheet.
Gets or sets a value that indicates whether the column width of the NamedRange control equals the standard width of the sheet.
Gets a Validation object that represents data validation for the NamedRange control.
Gets or sets the value of the NamedRange control.
Gets or sets the value of the NamedRange control.
Gets or sets the vertical alignment of the NamedRange control.
Gets the width of the NamedRange control in points.
Gets a Worksheet that represents the worksheet that contains the NamedRange control.
Gets or sets a value that indicates whether Microsoft Office Excel wraps the text in the NamedRange control.
Gets an XPath that represents the Xpath of the element mapped to the NamedRange control.
Top
Events
Name
Description
.gif "Public event")
Occurs when a NamedRange control is double-clicked, before the default double-click action.
Occurs when a NamedRange control is right-clicked, before the default right-click action.
Occurs when the value of the BindingContext property changes. (Inherited from RemoteBindableComponent.)
Occurs when something changes in the NamedRange control.
Occurs when selection moves from the NamedRange control to an area outside of the NamedRange control.
(Inherited from RemoteComponent.)
Occurs when the NamedRange control is selected.
Occurs when the selection inside the NamedRange control changes.
Top
Explicit Interface Implementations
Name
Description
.gif "Explicit interface implemetation")
.gif "Private method")
ISupportInitializeControl.InitializeControl
Infrastructure.
Top