CODEWITHSUNDEEP
excelvbaduplicates
Marc
Marc

Reputation: 352

RemoveDuplicates gives 1004 error

I want to remove duplicates from my selection, but this line gives me a 1004 error:

ActiveSheet.Range("B3", Range("B3").End(xlDown)).RemoveDuplicates Columns:=2, Header:=xlNo

How do I fix this?

Upvotes: 4

Views: 18302

Answers (1)

Kazimierz Jawor
Kazimierz Jawor

Reputation: 19067

Change your line into:

ActiveSheet.Range(range("B3"), Range("B3").End(xlDown)).RemoveDuplicates Columns:=1, Header:=xlNo

or,if you really have 2 columns into:

ActiveSheet.Range(range("B3"), Range("C3").End(xlDown)).RemoveDuplicates Columns:=2, Header:=xlNo

Upvotes: 6

Related Questions