Thread: [Solved] Removing duplicates
View Single Post
 
Old 05-25-2015, 01:40 PM
excelledsoftware excelledsoftware is offline Windows 8 Office 2003
IT Specialist
 
Join Date: Jan 2012
Location: Utah
Posts: 455
excelledsoftware will become famous soon enough
Default

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
Reply With Quote