If i remove the Data Validation and enter the number in manually the
macro runs fine. I dont know much about sheet change events. Do I have
to set it to True or False, or will that not help?


--
cbrd
------------------------------------------------------------------------
cbrd's Profile: http://www.excelforum.com/member.php...o&userid=30009
View this thread: http://www.excelforum.com/showthread...hreadid=498911