Dear all here,

First of all thank you very much for your previous help!! This Forum has been and is still of a great help for me and I am learning a lot thank to you!

I am asking now regarding a VBA (Macro code) for Deleting Duplicates

There is an option in Excel ("Remove Duplicates") and it does it in the number of cells selected.
It also removes the duplicate the is in the lower position.

Is there a VBA code, or Macro that
  1. DELETES DUPLICATES
  2. FROM TWO COLUMNS
  3. ONLY OF THE SELECTED CELLS
  4. AND CHOOSING WHICH OF THE TWO I WOULD LIKE TO REMOVE (upper or lower)?


THANK YOU VERY MUCH!

For example, I would like to remove duplicates of columns 2 and 3. Therefore Anna and Dandys lines are duplicates and Solomon and Kisas lines are also duplicates (Dandy and Kisas' lines would be deleted)
column1 column2 column3
Anna
001 01
Martha 002 02
Solomon 006 02
Dandy 001
01
Patricia 003 01
Frank 004 03
Sarah 004 04
Laurent 005 05
Kisa 006
02