Hi cogent

Range("A1").formula = "=abc"

--
XL2002
Regards

William



"cogent" wrote in message
...
| Hello
|
| When a named range is a formula and not a range, how does one refer to it
in
| code.
|
| Normally for example: workbook.worksheet.range("abc")
|
| but since there is no sheet identified with the named range as formula i
| cannot figure out how to call its value in the code.
|
| Please help.
|
| W
|
|