Named Range is a formula

C

cogent

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
 
W

William

Hi cogent

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

--
XL2002
Regards

William

[email protected]

| 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
|
|
 
V

Vasant Nanavati

ThisWorkbook.Names("abc").RefersTo

This is not a range. It is just a named formula.
 
C

Charles Williams

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
 
Top