...
Description |
---|
Excerpt |
---|
Creates a named Range of cells from a specified formula. A |
Signature | ||||
---|---|---|---|---|
| ||||
public Range CreateNamedRange(System.String rangeFormula, System.String rangeName)
{signature}{signature: |
Signature | ||||||
---|---|---|---|---|---|---|
| }
| |||||
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeName As String) As Range
{signature}
{parameters}
{param:rangeFormula}Formula representing the range, for example "=Sheet1\ |
Parameters |
---|
Param | ||||
---|---|---|---|---|
| ||||
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#} |
Param | ||||
---|---|---|---|---|
| ||||
The name to assign to the range. |
Returns |
---|
Range A |
Remarks |
---|
Note that if a range named |
Example | ||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|