How to: Refer to Worksheet Ranges in Code
The information in this topic applies only to the specified Visual Studio Tools for Office projects and versions of Microsoft Office.
Microsoft Office version
For more information, see Features Available by Application and Project Type.
You use a similar process to refer to the contents of a NamedRange control or a native Excel range object.
The following example adds a NamedRange to a worksheet and then adds text to the cell in the range.