That is it, thanks, Bob!
Stefi


€žBob Phillips€� ezt Ã*rta:

Activesheet.Evaluate("mydefname")

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Stefi" wrote in message
...
Hi All,

I have a defined name with a formula as its source, and it works in
worksheet functions. How can I retrieve its value in VBA?
For names with a normal range as source this line works:
ThisWorkbook.Names("mydefname").RefersToRange.Item (1, 1).Value
but I can't figure out a similar way for formula sources.

Thanks,
Stefi