Is there a maximun number of cells allowed in a name range?
I don't think there is any limit...
In Excel 2003 I defined ColsBIV as
=Sheet1!$B:$IV
and then used
=SUM(ColsBIV) in A1
result was (with 1 as the value in all cells in the range B:IV
851968
which shows that name ColsBIV refers to 851968 cells
"peingle" wrote:
It appears to be the case, but I don't know what the maximun is, or if my
error is for another reason.
|