Debra, I have tried to manually clear the old items, but it doesn't
work. They still appear in my lists and I have checked the source data
to confirm they are removed completely.

I had to resort to using the macro you have on your site, which did the
trick for me (thankfully). Thanks, but why didnt the manual method
work?


--
shadestreet
------------------------------------------------------------------------
shadestreet's Profile: http://www.excelforum.com/member.php...fo&userid=7092
View this thread: http://www.excelforum.com/showthread...hreadid=535116