Work with ranges
Applies to: 
Visual Studio 
Visual Studio for Mac
Note
This article applies to Visual Studio 2017. If you're looking for the latest Visual Studio documentation, see Visual Studio documentation. We recommend upgrading to the latest version of Visual Studio. Download it here
The NamedRange and Range classes contain the methods and properties you use to perform tasks with ranges.
| Task | Procedure |
|---|---|
| Access a range and set the value. | How to: Programmatically refer to worksheet ranges in code |
| Fill a range based on an initial value. | How to: Programmatically automatically fill ranges with incrementally changing data |
| Get and set date values in cells. | How to: Programmatically store and retrieve date values in Excel ranges |
| Apply styles to cells in a region. | How to: Programmatically apply styles to ranges in workbooks |
| Search for text in worksheet ranges. | How to: Programmatically search for text in worksheet ranges |
| Apply color to text in a range of cells. | How to: Programmatically apply color to Excel ranges |
| Run Excel calculations programmatically. | How to: Programmatically run Excel calculations |
| Display a string in a cell. | How to: Programmatically display a string in a worksheet cell |
For more information about Excel tasks and the Excel object model, see Excel object model overview.
In some cases, the ways that you perform these tasks in VSTO Add-ins is different from the ways that you perform them in document-level customizations.