this easy to do with a way nobody know any more. it take couple steps-

1. you give name "database" to the long list you want names removed ffrom.
include the headings in the named range and all colmns.
2. do same for same list but use name "criteria".
3. put this code in vb module and run it with the sheet with data active-

Sub DataDelete()
ExecuteExcel4Macro "data.delete()"
End Sub

i try this and it still work in excel 07

"LMK@work" wrote in message
...
|I have two email lists - one is a subset of the other. I would like to
remove
| all of the email addresses from the longer list that appear in the shorter
| list, leaving only the unique email addresses. I've tried using the
"Remove
| Duplicates" function, but it keeps telling me there are no duplicates. I'm
| not sure what to try next.