VBA macro to remove duplicates from multiple columns in excel sheet. It deletes duplicates in each column. You don't need a macro to remove duplicates from a single column.