VBA to delete Duplicate Records Excel

Question

I am trying to delete duplicate rows from my table and I thought this was straightforward enough looking at other examples online. Unfortunately, I am getting a type mismatch error on my variable. Also, I want the first instance from the bottom to be deleted not the first instance. So if row 5 and 27 are duplicates, I want row 27 to be deleted.

Here is my code:

Sub DeleteDuplicateRows()

Dim Rng As Range
With Worksheets("Database")

Set Rng = Range("C1", Range("Q1").End(xlDown))
    Rng.RemoveDuplicates Columns:=Array(3, 17), Header:=xlYes
End With

End Sub

Possible duplicate of Delete all duplicate rows Excel vba

Ken White
– Ken White

2018-04-02 16:52:51 +00:00
Commented Apr 2, 2018 at 16:52 — Ken White
– Ken White, Commented Apr 2, 2018 at 16:52

user4039065 · Accepted Answer · 2018-04-02 16:54:24Z

2

Array(1, 15) is column C and column Q within range C:Q.

Sub DeleteDuplicateRows()
    Dim Rng As Range

    With Worksheets("Database")
        Set Rng = .Range("C1", .Range("Q1").End(xlDown))
        Rng.RemoveDuplicates Columns:=Array(1, 15), Header:=xlYes
    End With
End Sub

answered Apr 2, 2018 at 16:54

user4039065

Sign up to request clarification or add additional context in comments.

2 Comments

Remi Over a year ago

Is this making sure C and Q aren't duplicates or is it C or Q?

user4039065 Over a year ago

C and Q. If you want C or Q then you need to do it twice; once for C and once for Q.

Collectives™ on Stack Overflow

VBA to delete Duplicate Records Excel

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related