Partager via


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: 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 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