Hi I am having some difficulty developing a macro.
I have a predefined list of 44 names in column A. I would like to match each name with a name from the same column, however no one name should match each other i.e A1=Tom, B1=Tom and the names that are being matched can only be used once.

it needs to use option explicit




Thanks in advance for you help
I will really appreciate it
Pop