Hi!

Yeah, I should have caught that myself. Sometimes I hurry my response
without thinking!

In addition to Ron's info, see this KB article:

http://support.microsoft.com/default...b;en-us;166342

Biff

"Jim May" wrote in message
news:meile.18790$Fv.15308@lakeread01...
Much appreciated Ron,
Jim

"Ron Rosenfeld" wrote in message
...
On Thu, 26 May 2005 04:16:09 -0400, "Jim May" wrote:

Are complete column references not usable for some reason?

You cannot use complete column references in array-formulas. The
<ctrl<shift<enter sequence makes this an array formula.

Worksheet arrays Limited by available memory. Also, arrays cannot refer
to
entire columns. For example, an array cannot refer to the entire column
C:C or
to the range C1:C65536. However, an array can refer to the range
C1:D65535
because the range is one row short of the maximum worksheet size and does
not
include the entire C or D column.

However, you can refer to entire rows.


--ron