Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
You can add NamedRange controls to a Microsoft Office Excel worksheet at design time or at run time in document-level projects.
By default, dynamically created named ranges are not persisted in the worksheet as host controls when the worksheet is closed. For more information, see Adding Controls to Office Documents at Run Time.
NamedRange controls can only consist of ranges on specific sheets. NamedRange controls cannot have relative names that apply to all sheets, and they cannot consist of ranges that span two or more worksheets in a workbook (3-D ranges).
A named range would appear to be a good candidate for complex data binding since it can have many cells; however, a range is merely a collection of cells that cannot be easily mapped to a particular column from a dataset. Therefore, NamedRange controls only support simple data binding. The ListObject control can be used for complex data binding. For more information, see ListObject Control.
If the data in the bound dataset is updated through any mechanism, the NamedRange control reflects the changes.
When you add a NamedRange control to your worksheet from the Toolbox, Visual Studio automatically generates a name for the control. You can change the name in the Properties window.