Printer Friendly Version      Send     
Click to Rate and Give Feedback
MSDN
MSDN Library
Visual Studio 2005
Visual Studio
Reference
NamedRange Class
This page is specific to
Microsoft Visual Studio 2005/.NET Framework 2.0

Other versions are also available for the following:
Excel Object Model Reference (Visual Studio Tools for Office)
NamedRange Properties

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