/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

1 vote162 views1 answer
Shortcut to apply a formula to an entire column in excel
VBA
0 vote155 views1 answer
Vba apostrophe chr
VBA
0 vote172 views1 answer
How to make a a msgbpx in vbs
VBA
0 vote155 views1 answer
VB get external IP address
VBA
0 vote159 views1 answer
Vba is integer
VBA
2 votes159 views1 answer
Vba ado ace sql alias ignored for calculated column
VBA
0 vote144 views1 answer
Faire appel à la mise en forme conditionnelle vba excel
VBA
1 vote168 views1 answer
Vba loop through files in folder
VBA
0 vote161 views2 answers
Vb.net include quotes in string
VBA
0 vote163 views1 answer
Excel run macro every 5 minutes
VBA