Description |
---|
Excerpt |
---|
Creates a named Range of cells from a specified formula. A |
Signature | ||||
---|---|---|---|---|
| ||||
public Range CreateNamedRange(System.String rangeFormula, System.String rangeName) |
Signature | ||||
---|---|---|---|---|
| ||||
Public Function CreateNamedRange(ByVal rangeFormula As String, ByVal rangeName As String) As Range |
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 | ||||
---|---|---|---|---|
| ||||
The name to assign to the range. |
Returns |
---|
Range A |
Remarks |
---|
Note that if a range named |
Example | ||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|