Try data validation again. The limits set can be copied for whole
columns by clicking Paste special and Validation option button.


--
raypayette


------------------------------------------------------------------------
raypayette's Profile: http://www.excelforum.com/member.php...o&userid=29569
View this thread: http://www.excelforum.com/showthread...hreadid=571909