.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+

How to: Create a Named Range of Cells

  • 2 minutes to read

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


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

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 specifed 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];

The image below shows the defined names of cell ranges in a worksheet (the workbook is opened in Microsoft® Excel®).


To learn how to use named ranges in formulas, see the How to: Use Names in Formulas document.

See Also