I'm have deleted all the data in the source table and it still doesn't
seem to work. i took out the "on error resume next" and it just errors
everytime it tries to delete an item.

i'm really not sure why its not working, the sheet isn't protected.

Steven Revell
Applications Development & Support
Covance Laboratories Europe, UK

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!