Excel Automation: getting the value of a named cell 1

[davikokar]

Hallo,

I have a cell with a name (example "test"). I don't know how to get the value contained in this cell.

I tried: ActiveWorkbook.Names("test").Value

but I get something like: =Sheet1!$A$1

Is there a way (in VBA) to obtain the value contained in a cell, by using its name, or its reference (=Sheet1$A$1) ?

Thanks

 

[PHV]

Why not simply this ?
Range("test").Value

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[davikokar]

thanks. like this it works