hi members,
i used data validation on my data consists of mor
than 6000 rows when i clicked on circle invalidation entries there wa
message(your worksheet contains more than 255 invalid cells.only th
first 255 cell will be marked) how can i increase that limit of 25
cells
JLatham - 17 Jun 2006 04:19 GMT
I doubt that you can change this. I searched around and cannot find a
reference to the limit. But 255 is a typical 8-bit counter limit and I
suspect that they are keeping count with an 8-bit counter.
> hi members,
>
[quoted text clipped - 3 lines]
> first 255 cell will be marked) how can i increase that limit of 255
> cells.