Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Param
rangeName
rangeName

The name of the new range.

Returns

A Range object.

Remarks

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.

Example
Code Block
csharp
csharp
titleC#

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

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