NamedRange Properties
Assembly: Microsoft.Office.Tools.Excel (in Microsoft.Office.Tools.Excel.dll)
| Name | Description | |
|---|---|---|
 | AddIndent | 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. |
| Address | Gets the range reference for the NamedRange control. |
| AddressLocal | Gets the range reference for the NamedRange control in the language of the user. |
| AllowEdit | Gets a value that indicates whether the NamedRange control can be edited on a protected worksheet. |
| Application | Gets a Microsoft.Office.Interop.Excel::Application that represents the creator of the NamedRange control. |
| Areas | Gets an Areas collection that represents all the ranges in a multiple-area selection. |
| BindingContext | (Inherited from IBindableComponent.) |
| Borders | Gets a Borders collection that represents the borders of the NamedRange control. |
| Cells | Gets a Microsoft.Office.Interop.Excel::Range that represents the cells in the NamedRange control. |
| Characters | Gets a Microsoft.Office.Interop.Excel::Characters object that represents a range of characters within the text of the NamedRange control. |
| Column | Gets the number of the first column in the first area of the NamedRange control. |
| Columns | Gets a Microsoft.Office.Interop.Excel::Range that represents the one or more columns in the NamedRange control. |
| ColumnWidth | Gets or sets the width of all columns in the NamedRange control. |
| Comment | Gets a Comment that represents the comment associated with the cell in the upper left corner of the NamedRange control. |
| Container | This API supports the product infrastructure and is not intended to be used directly from your code. |
| Count | Gets the number of cells in the NamedRange control. |
| CountLarge | Gets the number of occurrences of the largest value in a range of values. |
| Creator | Gets a 32-bit integer that indicates the application in which the NamedRange control was created. |
| CurrentArray | If the NamedRange control is part of an array, gets a Microsoft.Office.Interop.Excel::Range that represents the entire array. |
| CurrentRegion | Gets a Microsoft.Office.Interop.Excel::Range that represents the current region. |
| DataBindings | (Inherited from IBindableComponent.) |
| DefaultDataSourceUpdateMode | Gets or sets the default DataSourceUpdateMode. |
| Dependents | Gets a Microsoft.Office.Interop.Excel::Range that represents the range containing all the dependents of the NamedRange control. |
| DirectDependents | Gets a Microsoft.Office.Interop.Excel::Range that represents the range containing all the direct dependents of the NamedRange control. |
| DirectPrecedents | Gets a Microsoft.Office.Interop.Excel::Range that represents the range containing all the direct precedents of the NamedRange control. |
| DisplayFormat | Gets an object that represents the display settings for the specified range. |
| End | Gets a Microsoft.Office.Interop.Excel::Range that represents the cell at the end of the region that contains the NamedRange control. |
| EntireColumn | Gets a Microsoft.Office.Interop.Excel::Range that represents the entire column (or columns) that contains the NamedRange control. |
| EntireRow | Gets a Microsoft.Office.Interop.Excel::Range that represents the entire row (or rows) that contains the NamedRange control. |
| Errors | Gets an Errors object that enables you to access error checking options. |
| Font | Gets a Font that represents the font of the NamedRange control. |
| FormatConditions | Gets a FormatConditions collection that represents all the conditional formats for the NamedRange control. |
| Formula | Gets or sets the NamedRange control's formula in A1-style notation. |
| FormulaArray | Gets or sets the array formula of the NamedRange control. |
| FormulaHidden | Gets or sets a value that indicates whether the formula in the NamedRange control will be hidden when the worksheet is protected. |
| FormulaLocal | Gets or sets the formula for the NamedRange control, using A1-style references in the language of the user. |
| FormulaR1C1 | Gets or sets the formula for the object, using R1C1-style notation. |
| FormulaR1C1Local | Gets or sets the formula for the NamedRange control, using R1C1-style notation in the language of the user. |
| HasArray | Gets a value that indicates whether the NamedRange control is part of an array formula. |
| HasFormula | Gets a value that indicates whether all cells in the NamedRange control contain formulas. |
| Height | Gets the height of the NamedRange control. |
| Hidden | Gets or sets an object that indicates whether the rows or columns are hidden. |
| HorizontalAlignment | Gets or sets the horizontal alignment for the NamedRange control. |
| Hyperlinks | Gets a Hyperlinks collection that represents the hyperlinks in the NamedRange control. |
| ID | Gets or sets the identifying label for the NamedRange control when the page is saved as a Web page. |
| IndentLevel | Gets or sets the indent level for the NamedRange control. |
| InnerObject | Gets a Microsoft.Office.Interop.Excel::Range that represents the underlying native object for the Microsoft.Office.Tools.Excel::NamedRange. |
| Interior | Gets an Interior that represents the interior of the NamedRange control. |
| Item | Gets a Microsoft.Office.Interop.Excel::Range that represents a range at an offset to the NamedRange control. |
| Left | Gets the distance from the left edge of column A to the left edge of the NamedRange control. |
| ListHeaderRows | Gets the number of header rows for the NamedRange control. |
| ListObject | Gets a Microsoft.Office.Interop.Excel::ListObject for the NamedRange control. |
| LocationInTable | Gets a constant that describes the part of the PivotTable report that contains the upper-left corner of the NamedRange control. |
| Locked | Gets or sets a value that indicates whether the NamedRange control is locked. |
| MDX | Gets the MDX name for the specified NamedRange object. |
| MergeArea | Gets a Microsoft.Office.Interop.Excel::Range that represents the merged range containing the NamedRange control. |
| MergeCells | Gets or sets a value that indicates whether the NamedRange control contains merged cells. |
| Name | Gets or sets a Name object for the NamedRange control. |
| Next | Gets a Microsoft.Office.Interop.Excel::Range that represents the next cell. |
| NumberFormat | Gets or sets the format code for the NamedRange control. |
| NumberFormatLocal | Gets or sets the format code for the NamedRange control in the language of the user. |
| Offset | Gets a Microsoft.Office.Interop.Excel::Range that is offset from the NamedRange control. |
| Orientation | Gets or sets the text orientation. |
| OutlineLevel | Gets or sets the current outline level of the NamedRange control. |
| PageBreak | Gets or sets the location of a page break. |
| Parent | Gets the parent object of the NamedRange control. |
| Phonetic | Gets the Phonetic object, which contains information about a specific phonetic text string in the NamedRange control. |
| Phonetics | Gets the Phonetics collection of the NamedRange control. |
| PivotCell | Gets a PivotCell that represents a cell in a PivotTable report. |
| PivotField | Gets a PivotField that represents the PivotTable field containing the upper left corner of the NamedRange control. |
| PivotItem | Gets a PivotItem that represents the PivotTable item containing the upper left corner of the NamedRange control. |
| PivotTable | 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. |
| Precedents | Gets a Microsoft.Office.Interop.Excel::Range that represents all the precedents of the NamedRange control. |
| PrefixCharacter | Gets the prefix character for the NamedRange control. |
| Previous | Gets a Microsoft.Office.Interop.Excel::Range that represents the previous cell. |
| QueryTable | Gets a QueryTable that represents the query table that intersects the NamedRange control. |
| ReadingOrder | Gets or sets the reading order for the NamedRange control. |
| RefersTo | Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation. |
| RefersToLocal | Gets or sets the formula that the NamedRange control is defined to refer to, using A1-style notation in the language of the user. |
| RefersToR1C1 | Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation. |
| RefersToR1C1Local | Gets or sets the formula that the NamedRange control is defined to refer to, using R1C1-style notation in the language of the user. |
| RefersToRange | Gets the Microsoft.Office.Interop.Excel::Range referred to by a NamedRange control. |
| Resize | Gets a resized Microsoft.Office.Interop.Excel::Range based on the NamedRange control. |
| Row | Gets the number of the first row of the first area in the NamedRange control. |
| RowHeight | Gets or sets the height of all the rows in the NamedRange control, measured in points. |
| Rows | Gets a Microsoft.Office.Interop.Excel::Range that represents one or more rows in the NamedRange control. |
| ServerActions | Gets the actions that can be performed on the Microsoft Office SharePoint server for a NamedRange object. |
| ShowDetail | 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). |
| ShrinkToFit | Gets or sets a value that indicates whether text automatically shrinks to fit in the available column width. |
| Site | (Inherited from IComponent.) |
| SoundNote | This API supports the product infrastructure and is not intended to be used directly from your code. |
| SparklineGroups | Gets an object that represents an existing group of sparklines from the specified range. |
| Style | Gets or sets a Style that represents the style of the NamedRange control. |
| Summary | Gets a value that indicates whether the range is an outlining summary row or column. |
| Tag | Gets or sets the object that contains data about the Tag control. |
| Text | Gets the text for the NamedRange control. |
| Top | Gets the distance, in points, from the top edge of row 1 (one) to the top edge of the NamedRange control. |
| UseStandardHeight | Gets or sets a value that indicates whether the row height of the NamedRange control equals the standard height of the sheet. |
| UseStandardWidth | Gets or sets a value that indicates whether the column width of the NamedRange control equals the standard width of the sheet. |
| Validation | Gets a Validation object that represents data validation for the NamedRange control. |
| Value | Gets or sets the value of the NamedRange control. |
| Value2 | Gets or sets the value of the NamedRange control. |
| VerticalAlignment | Gets or sets the vertical alignment of the NamedRange control. |
| Width | Gets the width of the NamedRange control in points. |
| Worksheet | Gets a Microsoft.Office.Interop.Excel::Worksheet that represents the worksheet that contains the NamedRange control. |
| WrapText | Gets or sets a value that indicates whether Microsoft Office Excel wraps the text in the NamedRange control. |
| XPath | Gets an XPath that represents the Xpath of the element mapped to the NamedRange control. |