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. |
|
Fill a range based on an initial value. |
How to: Automatically Fill Ranges with Incrementally Changing Data |
Get and set date values in cells. |
|
Apply styles to cells in a region. |
|
Search for text in worksheet ranges. |
|
Apply color to text in a range of cells. |
|
Run Excel calculations programmatically. |
|
Display a string in a 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.