Working with Ranges


The NamedRange and Range classes contain the methods and properties you use to perform tasks with ranges.

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

Automating Excel by Using Extended Objects
Working with Worksheets
Working with Workbooks
Using Windows Forms Controls on Excel Worksheets