Hi W

if you want the result of the named formula rather than the formula itself
then use Evaluate

if namedformula has a refersto of =5*2/3 you will get 3.3333 returned to
vArr

dim vArr as variant
varr=application.evaluate("NamedFormula")

or
varr=[NamedFormula]

for a general purpose wrapper function for Evaluate see
http://www.decisionModels.com/calcsecretsh.htm

regards
Charles
______________________
Decision Models
FastExcel Version 2 now available.
www.DecisionModels.com/FxlV2WhatsNew.htm

"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