VBA macro to remove duplicates from each column [Excel]

VBA macro to remove duplicates from each individual column in excel sheet. This simple macro,  just single line syntax, treats each column as a separate entity and removes all duplicates from each column and keeps only unique values.

vba-macro-remove-duplicates-each-column

VBA macro code to remove duplicates from each column

If you want to remove duplicates from a single column, you don’t need a macro. Follow below steps

Remove duplicates from a single column without VBA macro

  1. Select the column from which you want to delete duplicates
  2. Click on Data tab
  3. Click on Remove Duplicates under Data tools group

remove-duplicates-location-in-data-tab-microsoft-excel