How to: Refer to Worksheet Ranges in Code
Some code examples in this topic use the this or Me keyword or the
Theclass is quite flexible. Sometimes a range is a single object, and other times it represents a collection of objects. It has and members, even though a range often refers to a single object, making it sometimes confusing to figure out exactly how to use a Microsoft.Office.Interop.Excel.Range object.
The range can be one of two types:
Native Excel object.
Excel Microsoft.Office.Interop.Excel.Range objects do not have events or data binding capabilities.
Using Host Controls
To refer to a NamedRange control
Using Excel Objects
To refer to a named Range object
Compiling the Code
This code must be placed in a sheet class, not in the