Hi, How to remove duplicate values from specific column using Macro

Question

Below mentioned code is nor working, is there anything to be modified?

Sub duplicate()
ActiveSheet.Range("$A$1:$T$65535").RemoveDuplicates Columns:=15, Header:= _
    xlYes

End Sub

Read here: http://stackoverflow.com/questions/31631231/remove-duplicates-from-range-of-cells-in-excel-vba — Shai Rado, Aug 14 '16 at 05:39
@ShaiRado, Thanks but that code is not working. I have 20 columns in my sheet and i want to remove duplicates in column 15. — Siva, Aug 14 '16 at 05:56
you can also reply to the answer I gave you on your previous question — Shai Rado, Aug 14 '16 at 06:21

score 0 · Answer 1 · answered Aug 14 '16 at 06:26

0

paste below code in vba

Sub duplicate()

ActiveSheet.Range("$A$1:$T$65535").RemoveDuplicates Columns:=15, Header:=xlNo

End Sub

answered Aug 14 '16 at 06:26

my Name is Ammu

You really didn't need to post three separate answers for all of this. – Jamal Aug 14 '16 at 06:44

1 Answers1