The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.

How to: Create a Named Range of Cells

  • 2 min 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.

Note

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®).

Spreadsheet_NamedRange

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

See Also