I've never used AREAS, never seen it used, and like Ron, wonder how it can
be used for anything useful!

Biff

"JMB" wrote in message
...
They need to do more market research. Or maybe they're saving it for
Office
2010? I'm sure it's on the to do list (right after fixing COMBIN).

It would be nice to have a CONCAT that would work w/ranges and in array
formulae. I've wanted to do that more than once.


"Biff" wrote:

Well, it was either the AREAS(Range) function or the CONCAT(Range, ",")
function. There wasn't room for both!

There was so much demand for the Areas function that it got the nod.

Biff

"JMB" wrote in message
...
I had to look it up in help to make sure there was such a worksheet
function.
I've never seen anybody use it, FWVLIW.


"Ron Rosenfeld" wrote:

On Mon, 31 Jul 2006 00:08:09 +0100, "Bob Phillips"
wrote:

Thought I was in the programming group!

Yeah. I've never used the Areas worksheet function and was also
wondering
about
how it might be useful.


--ron