Once you've found the next duplicate what do you then want to do?

What about filtering the column of names for a particular name and you'll then see all the duplicate names and no need for a macro at all.