Hi

Try this:

MyVar = Range("SpecialNumber").Value

Regards,
Per

"Jorge Ribeiro" skrev i meddelelsen
...
Hello

I've a workbook with several named ranges defined. (Excel 2007)

I've a named range say SpecialNumber that refers to System!$a$20
My name is well formed because in name manager i can see it and using
it on a worksheet it functions great.

My problem is to retrieve the value pointed to by that named range

When i try Range("SpecialNumber") it reports an error.
Using thisWorkbook.Names("SpecialNumber").RefersTo returns =System!$a$20
and using thisWorkbook.Names("SpecialNumber").Value it returns the same
=System!$a$20

How can i retrieve the underlying value of the named range, that is, the
value of
cell $a$20 in sheet System

I'me going mad!!!

thanx in advance!

regads

Jorge