Description |
---|
Excerpt |
---|
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. |
Signature | C# | C# |
---|---|---|
Wiki Markup | ||
{description}
{excerpt}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.{excerpt}
{signature:C#}
public Range CreateNamedRange(System.String rangeFormula, System.String rangeName)
| ||
Signature | ||
{signature}{signature:vb.net | vb.net | }
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeName As String) As Range
|
Parameters |
---|
Param | ||
---|---|---|
rangeFormula | rangeFormula | Formula representing the range, for example "=Sheet1{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 ','\). |
Param | rangeName | rangeName |
The name of the new range. |
Returns |
---|
A Range object. |
Remarks |
---|
Note that if a range named |
Example | |||
---|---|---|---|
Code Block | | csharp | csharp |
title | C# | ||
Code Block | vb.net | title |