Creates a named range from a specified formula. A range is a collection of areas; an area is a rectangular collection of cells. This method can be used to create a non-rectangular range containing multiple rectangular areas.

 public Range CreateNamedRange(System.String rangeFormula, System.String rangeName)
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeName As String) As Range

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 ',').

The name of the new range.

A Range object.

Note that if a range named rangeName already exists in the worksheet, it will be overwritten with the new named range created by this method.


          Range rng =
               ws.CreateRange("=Sheet1!$B$12:$H$21 Sheet1!$F$18:$K$29", "Range1");
        

          Dim rng As Range = _
               ws.CreateRange("=Sheet1!$B$12:$H$21 Sheet1!$F$18:$K$29", "Range1")