Name not recognised
I tried, it doesnt work....
-----Original Message-----
Try =INDIRECT(SUM(B1))
--
HTH
Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)
"Jerome_t" wrote
in message
...
Hi everybody,
Here is my problem:
I put data (numbers) in book1, sheet1, cells A1:A10.
book1 is closed. I create a name (toto) in book2
referencing cells A1:A10 in book1. In book2, If I write
=Sum(toto) I get the right result. However, if I write
=Sum(indirect(B1)) with cells B1 containing the
string "toto", I get an error.
NB1: If you insert this last expression with the
function
wizard you'll see the right result in the wizard, but
it
changes to an error when you hit the enter key !
NB2: the indirect.ext function of morefunc.xll is ok
for
single cells, not for a range.
.
|