/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 votes179 views2 answers
Vba check if file exists
VBA
12 votes168 views1 answer
Excel vba write string to text file
VBA
0 vote122 views1 answer
Vbnet chart make 0 gridline line different color
VBA
0 vote76 views1 answer
How to sort datagridview in vb.net
VBA
0 vote130 views1 answer
Delete rows in excel vba code
VBA
0 vote115 views1 answer
Vba option button selected
VBA
0 vote159 views1 answer
Vba array of integers
VBA
7 votes122 views1 answer
Excerl vba array to range
VBA
0 vote132 views1 answer
Vba boolean to string
VBA
0 vote113 views1 answer
Vbnet get file name from path
VBA