Working with Ranges

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: Refer to Worksheet Ranges in Code
Fill a range based on an initial value.	How to: Automatically Fill Ranges with Incrementally Changing Data
Get and set date values in cells.	How to: Store and Retrieve Date Values in Excel Ranges
Apply styles to cells in a region.	How to: Apply Styles to Ranges in Workbooks
Search for text in worksheet ranges.	How to: Search for Text in Worksheet Ranges
Apply color to text in a range of cells.	How to: Apply Color to Excel Ranges
Run Excel calculations programmatically.	How to: Run Excel Calculations Programmatically
Display a string in a cell.	How to: 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 application-level add-ins is different from the ways that you perform them in document-level customizations.

See Also

Concepts

Automating Excel by Using Extended Objects

Working with Worksheets

Working with Workbooks

Using Windows Forms Controls on Excel Worksheets