Yeah I can see the attractions of that approach <G, I am not a fan of
INDIRECT normally, but I just prefer formulae to functions unless there is a
performance hit.

Regards

Bob


"Kurt Swanson" wrote in message
...
Indeed, after reading this I made an unsuccessful attempt to reproduce
the problem. Your solution does indeed work. My apologies.

I think I;ll stick with my function solution, for a couple reasons:
a) the range definitions are standard entry, not strings (can
drag-select, automatics updates with row/column insertions/deletions,
etc.)
b) the resultant cell entries are shorter

"Bob Phillips" writes:
Well, it works for me, and it did for Ron as well I see.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Kurt Swanson" wrote in message
...
"Bob Phillips" writes:
See my response.

I did. It didn't work.
--
© 2005 Kurt Swanson AB



--
© 2005 Kurt Swanson AB