The code that fills the list box add this to the top
list1.clear
This way it will clear it each time the code is calle
--
drawling
-----------------------------------------------------------------------
drawlings's Profile:
http://www.excelforum.com/member.php...fo&userid=3662
View this thread:
http://www.excelforum.com/showthread.php?threadid=57258