How to: Create a Named Range of Cells

• Jun 07, 2019
• 2 minutes to read

Tip

A complete sample project is available in the DevExpress Code Examples database at https://supportcenter.devexpress.com/ticket/details/e4938/wpf-spreadsheetcontrol-api-part-1.

This example demonstrates how to create a named range of cells in a worksheet. You can do this in one of the following ways.

• Use the Worksheet.Range property to access a cell range (see the How to: Access a Range of Cells document for details). Then, specify the range name via the CellRange.Name property of the created CellRange object.
• Use the DefinedNameCollection.Add method to add a new defined name for the specified range to the worksheet’s collection of defined names (Worksheet.DefinedNames). Then, use the Worksheet.Range property and pass the DefinedName.Name property value of the previously created defined name object.

Note

When specifying a name for a cell or range of cells, follow the rules listed in the Defined Names document.

C#

Worksheet worksheet = workbook.Worksheets[0];

// Create a range.
CellRange rangeB3D6 = worksheet.Range["B3:D6"];
// Specify the name for the created range.
rangeB3D6.Name = "rangeB3D6";

// Create a new defined name with the specified range name and absolute reference.
DefinedName definedName = worksheet.DefinedNames.Add("rangeB17D20", "Sheet1!$B$17:$D$20");
// Create a range using the specified defined name.
CellRange B17D20 = worksheet.Range[definedName.Name];

VB.NET

Dim worksheet As Worksheet = workbook.Worksheets(0)

' Create a range.
Dim rangeB3D6 As CellRange = worksheet.Range("B3:D6")
' Specify the name for the created range.
rangeB3D6.Name = "rangeB3D6"

' Create a new defined name with the specifed range name and absolute reference.
Dim definedName As DefinedName = worksheet.DefinedNames.Add("rangeB17D20", "Sheet1!$B$17:$D$20")
' Create a range using the specified defined name.
Dim B17D20 As CellRange = worksheet.Range(definedName.Name)