How to: Programmatically Refer to Worksheet Ranges in Code

Article
11/06/2012

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";

Share via

How to: Programmatically Refer to Worksheet Ranges in Code

Using a NamedRange Control

To refer to a NamedRange control

Using Native Excel Ranges

To refer to a native range object

See Also

Tasks

Concepts

Additional resources