| |
 |
How to: Create a Named Range of Cells
This example demonstrates how to create a named range of cells in a worksheet. You can do this in one of the following ways.
Note
When specifying a name for a cell or range of cells, follow the rules listed in the Defined Names document.
| C# |
using DevExpress.Spreadsheet;
IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];
CellRange rangeA2A4 = worksheet.Range["A2:A4"];
rangeA2A4.Name = "rangeA2A4";
DefinedName definedName = worksheet.DefinedNames.Add("rangeC2D3", "Sheet1!$C$2:$D$3");
CellRange rangeC2D3 = worksheet.Range[definedName.Name];
|
| VB |
Imports DevExpress.Spreadsheet
Dim workbook As IWorkbook = spreadsheetControl1.Document
Dim worksheet As Worksheet = workbook.Worksheets(0)
Dim rangeA2A4 As CellRange = worksheet.Range("A2:A4")
rangeA2A4.Name = "rangeA2A4"
Dim definedName As DefinedName = worksheet.DefinedNames.Add("rangeC2D3", "Sheet1!$C$2:$D$3")
Dim rangeC2D3 As CellRange = worksheet.Range(definedName.Name)
|
To learn how to use named ranges in Formulas, see the How to: Use Names in Formulas document.
 
See Also
Is this topic helpful?
Additional Feedback
Close
|