How to: 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 2007 and Excel 2010. For more information, see Features Available by Office Application and Project Type.

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.

    
    Microsoft.Office.Tools.Excel.NamedRange NamedRange1 =
        this.Controls.AddNamedRange(this.get_Range("A1", missing), "NamedRange1");
    
    NamedRange1.Value2 = "Range value";
    
    
    

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.

    
    Excel.Range rng = this.Application.get_Range("A1", missing);
    
    rng.Value2 = "Range value";
    
    
    
Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2015 Microsoft