/VBA/Vba code to remove duplicates from a column

Vba code to remove duplicates from a column

 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: stackoverflow.com

Vba code to remove duplicates from a column

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: stackoverflow.com

Similar codes

27 votes263 views2 answers
Vba check if file exists
VBA
0 vote147 views1 answer
Vba min
VBA
0 vote135 views1 answer
Vba get text file content
VBA
0 vote138 views1 answer
Loop through each cell in dgv vbnet
VBA
0 vote148 views1 answer
VBA
VBA
0 vote151 views2 answers
Open url from vba
VBA
0 vote130 views1 answer
Vbnet chart make 0 gridline line different color
VBA
4 votes132 views1 answer
Excel vba determine number of elements in an array
VBA
0 vote151 views1 answer
Vbnet check if string is only numbers
VBA
0 vote146 views1 answer
Find database connection string vb
VBA