| |
 |
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.
NoteWhen 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];
Range rangeA2A4 = worksheet.Range["A2:A4"];
rangeA2A4.Name = "rangeA2A4";
DefinedName definedName = worksheet.DefinedNames.Add("rangeC2D3", "Sheet1!$C$2:$D$3");
Range 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 Range = worksheet.Range("A2:A4")
rangeA2A4.Name = "rangeA2A4"
Dim definedName As DefinedName = worksheet.DefinedNames.Add("rangeC2D3", "Sheet1!$C$2:$D$3")
Dim rangeC2D3 As Range = 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
|