How to: Programmatically Refer to Worksheet Ranges in Code
You use a similar process to refer to the contents of a NamedRange control or a native Excel range object.
Applies to: The information in this topic applies to document-level projects and application-level projects for Excel 2013 and Excel 2010. For more information, see Features Available by Office Application and Project Type.
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
Assign a string to the Value2 property of the Microsoft.Office.Tools.Excel.NamedRange control. This code must be placed in a sheet class, not in the ThisWorkbook class.
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"), "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"); rng.Value2 = "Range value";
See Also
Tasks
How to: Programmatically Check Spelling in Worksheets
How to: Programmatically Apply Styles to Ranges in Workbooks
How to: Programmatically Automatically Fill Ranges with Incrementally Changing Data
How to: Programmatically Search for Text in Worksheet Ranges
Concepts
Host Items and Host Controls Overview