Hi,

How can I set the validation like this formula?
=countif(rngCheckColumn, CheckCelladdr)<=1


--
gabch
------------------------------------------------------------------------
gabch's Profile: http://www.excelforum.com/member.php...o&userid=30662
View this thread: http://www.excelforum.com/showthread...hreadid=542368