Actually this code has a bug. It only checks for the first name and not the last name. If you change a first name to Jacob the code will show that there is a duplicate when in fact there is not. Also I am not sure if msgboxes are the most efficient way to let the user know what duplicates to remove. I am curious about the solution to this myself so I am working on a sub that should do it. However since Bruno spent some time on providing a "in the works" solution I would like to see if he wants to fix the issues before I submit my code.
Thanks
|