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 VSTO add-in projects for Excel. 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

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

   C#

   VB

   C++

   Copy

   No code example is currently available or this language may not be supported.

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

1. Assign a string to the Value2 property of the range.

   C#

   VB

   C++

   Copy

   No code example is currently available or this language may not be supported.

Working with Ranges
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
NamedRange Control
Host Items and Host Controls Overview
Programmatic Limitations of Host Items and Host Controls
Optional Parameters in Office Solutions