| Name | Description | |
|---|---|---|
 | DefinedName Constructor | Creates a defined name. |
The following tables list the members exposed by DefinedName.
| Name | Description | |
|---|---|---|
| DefinedName Constructor | Creates a defined name. |
| Name | Description | |
|---|---|---|
 | Name | The name of the defined name item. |
| SheetName | Indicates the defined name item works in which sheet. If omitted, the defined name item works in workbook. |
| Value | The value of the defined name item. The value could be a formula, a string constant or a cell range. For e.g. "Sum(1, 2, 3)", "1.2", "\"test\"" or "sheet1!A1:B2". |