Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes

Question

Previous Topic Next Topic

Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes

[Solved/Closed]

Report

jackied25

Posts: 1
Registration date: Friday February 28, 2020
Status: Member
Last seen: February 28, 2020

- Feb 28, 2020 at 09:07 AM
TrowaD

Posts: 2783
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 3, 2021

- Mar 3, 2020 at 12:17 PM

Hello All,

I have been struggling to find a code that allows me to select multiple columns by name to then delete duplicates in those specific columns. The reason behind this is the workbook i am using will soon be adding columns and i need to specifically reference these exact columns rather than the numerical placement of the columns. If anyone can help that would be great!

Macro to delete multiple columns based on header
Need to delete columns based on Column header ✓ - Forum - Excel
Excel Macro - Multiple Columns Into One ✓ - Forum - Excel
Excel data validation list from table multiple columns - How-To - Excel
Excel macro to group by column and sum value ✓ - Forum - Excel
Excel macro find date in column ✓ - Forum - Excel

2 replies

Answer 2 / 2

TrowaD

Posts: 2783
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 3, 2021

468
Mar 3, 2020 at 12:17 PM

Hi Jackied,

Having a second look at your title, the following code might be what you are after:

Sub RunMe()
For Each cell In Range(Cells(1, 1), Cells(1, Columns.Count).End(xlToLeft))
    If cell.Value = "Dupes" Then
        Range(Cells(2, cell.Column), Cells(Cells(Rows.Count, cell.Column).End(xlUp).Row, cell.Column)).RemoveDuplicates Columns:=1
    End If
Next cell
End Sub

Every column with a header named "Dupes" will get it's dupes removed. Change the word Dupes on the 3rd code line if you have/want another header name to trigger the removal of duplicates.

Best regards,
Trowa

Ask a question

TrowaD · Accepted Answer · 2020-03-02T11:50:43-0500

Answer 1 / 2

TrowaD

Posts: 2783
Registration date: Sunday September 12, 2010
Status: Moderator
Last seen: August 3, 2021

468
Mar 2, 2020 at 11:50 AM

Hi Jackied,

Not sure what you mean by select column by name? Do you mean by Header name or Column letter or Named range or something else?

And where are those names located for Excel to know which columns need to remove duplicates? Or do you want to be prompted for each column?

Best regards,
Trowa

Macro to Select Multiple Columns by Columns Specific Headings to Delete Dupes

2 replies

Your reply

Subscribe To Our Newsletter!