1. Sekolah Dasar
  2. Sekolah Menengah Pertama
  3. Sekolah Menengah Atas
  4. Mata Pelajaran
  5. Programming

Vba Code To Remove Duplicates From A Column

[Solved] Vba Code To Remove Duplicates From A Column | Vb - Code Explorer | yomemimo.com
Question : vba code to remove duplicates from a column

Answered by : rajesh-thevar

 Sub removeDuplicate() 'removeDuplicate Macro Columns("A:A").Select ActiveSheet.Range("$A$1:$A$117").RemoveDuplicates Columns:=Array(1), _ Header:=xlNo Range("A1").Select End Sub

Source : https://stackoverflow.com/questions/31631231/remove-duplicates-from-range-of-cells-in-excel-vba | Last Update : Mon, 28 Sep 20

Question : vba code to remove duplicates from a column

Answered by : rajesh-thevar

Sub dedupe_abcd() Dim icol As Long With Sheets("Sheet1") '<-set this worksheet reference properly! icol = Application.Match("abcd", .Rows(1), 0) With .Cells(1, 1).CurrentRegion .RemoveDuplicates Columns:=icol, Header:=xlYes End With End With
End Sub

Source : https://stackoverflow.com/questions/31631231/remove-duplicates-from-range-of-cells-in-excel-vba | Last Update : Mon, 28 Sep 20

Answers related to vba code to remove duplicates from a column

Code Explorer Popular Question For Vb