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

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

Is this making sure C and Q aren't duplicates or is it C or Q?
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

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Linked

Related