Page History

{description}
{excerpt}Creates a named [Range|Range] of cells from a specified formula. A {{Range}} is a collection of [Area|Area] s; an {{Area}} area is a rectangular collection of cells.{excerpt}
{signature:C#}
 public Range CreateNamedRange(System.String rangeFormula, System.String rangeName)
{signature}{signature:vb.net}
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeName As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example "=Sheet1\!A1:G10". The formula must be three\-dimensional \(specify a sheet\), and can include only sheet and cell references, and operators joining those references \(range ':', intersection ' ', and union ','\). Functions that return ranges cannot be used.{param}
{param:rangeName}The name to assign to the range.{param}
{returns}Range A {{Range}} object representing the range of cells created.{returns}
{remarks}
Note that if a range named {{rangeName}} already exists in the workbook, it will be overwritten with the new named range created by this method.
{remarks}
{example}{code:csharp|title=C#}
Range rng = wb.CreateNamedRange("=Sheet1!A1:G10", "Range1");{code}
{code:vb.net|title=vb.net}
Dim rng As Range = wb.CreateNamedRange("=Sheet1!A1:G10", "Range1"){code}

{example}