Can anyone please help me VB script code to delete the Duplicate records in excel.
Actually I already have one code which works in macro but its giving me error in our VB script plugin.
Below is the code which is working in macro
Range(“A1:T20000”).RemoveDuplicates Columns:=2, Header:=xlNo
Do not know what you are project is about. If writing to excel and you want to remove duplicates, I would use the AE plugin Unique Rows. Much more efficient the going with VB.
Hope this helps.
I cant use unique rows as to use unique rows the coloumn has to be sorted. and I can’t sort the rows. so I am preferring VB Script.
RemoveDuplicates in VBA Excel Duplicate values are often not required in excel, especially when you want to have unique values count. We usually have a
Est. reading time: 7 minutes
go through this once for your reference