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