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

Working with Ranges

NamedRange Control

Host Items and Host Controls Overview

Programmatic Limitations of Host Items and Host Controls

Optional Parameters in Office Solutions