Delete row if duplicate on more than a col

Question

I have this code:

Workbooks("Test.xlsx").Worksheets("Sheet1").Range("A:D").RemoveDuplicates Columns:=1, Header:=xlNo

The problem is that if at least 1 duplicate is found it deletes the entire row.

I need something like this:

If (duplicate is found on on columns A & C) then delete entire row

I mean delete the row where columns A has duplicates of above/below rows on it and also column C contains duplicates of above/below rows.

Any help would be appreciated! Thank you!

@Sid thats not an obvious solution, and would warrant an answer — chris neilsen
– chris neilsen, Commented Mar 26, 2020 at 7:18

Siddharth Rout · Accepted Answer · 2020-03-26 07:23:01Z

1

Whenever in doubt, record a macro. To record a macro you may want to see Automate tasks with the Macro Recorder

When you are recording a macro, do this...

You will get a code which is something like this

YourRange.RemoveDuplicates Columns:=Array(1, 3), Header:=xlNo

answered Mar 26, 2020 at 7:23

Siddharth Rout

150k18 gold badges212 silver badges258 bronze badges

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

1 Answer 1