data validation
 

hi members,

i used data validation on my data consists of more
than 6000 rows when i clicked on circle invalidation entries there was
message(your worksheet contains more than 255 invalid cells.only the
first 255 cell will be marked) how can i increase that limit of 255
cells.


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=552659

data validation
 

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.

"b166er" wrote:


hi members,

i used data validation on my data consists of more
than 6000 rows when i clicked on circle invalidation entries there was
message(your worksheet contains more than 255 invalid cells.only the
first 255 cell will be marked) how can i increase that limit of 255
cells.


--
b166er
------------------------------------------------------------------------
b166er's Profile: http://www.excelforum.com/member.php...o&userid=34912
View this thread: http://www.excelforum.com/showthread...hreadid=552659