Quite right Ron, it was 65535 I used, not 65536.

--
Regards

Roger Govier


"Ron Rosenfeld" wrote in message
...
On Fri, 6 Jan 2006 12:49:06 -0000, "Roger Govier"
wrote:

Hi Ron

Just one small caveat for the OP, range cannot be a whole column.
I had thought that would be the solution, and tried {=MAX(LEN(A:A))}
which failed with a #VALUE error.
Changing the range to A1:A65536 resolved the problem.

--
Regards

Roger Govier

I don't think so. You would have to change the range to A1:A65535.

This is clearly laid out in Excel's Specifications.

Also note that this is not a size limit, merely a limit on using an
entire
column. For example A1:B65535 would be valid.


--ron