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.
Using a NamedRange Control
The following example adds a NamedRange to a worksheet and then adds text to the cell in the range.
To refer to a NamedRange control
Dim NamedRange1 As Microsoft.Office.Tools.Excel.NamedRange = _ Me.Controls.AddNamedRange(Me.Range("A1"), "NamedRange1") NamedRange1.Value2 = "Range value"
Microsoft.Office.Tools.Excel.NamedRange NamedRange1 = this.Controls.AddNamedRange(this.get_Range("A1", missing), "NamedRange1"); NamedRange1.Value2 = "Range value";
Using Native Excel Ranges
The following example adds a native Excel range to a worksheet and then adds text to the cell in the range.
To refer to a native range object
Assign a string to the Value2 property of the range.
Dim rng As Excel.Range = Me.Application.Range("A1") rng.Value2 = "Range value"
Excel.Range rng = this.Application.get_Range("A1", missing); rng.Value2 = "Range value";