NamedRange Properties (2007 System)
Include Protected Members
Include Inherited Members
The NamedRange type exposes the following members.
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