/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

2 votes197 views1 answer
Excel vba date to string conversion
VBA
3 votes196 views1 answer
Excel vba get the workbook full file name with path
VBA
0 vote219 views1 answer
Prive sub enter clicked vb
VBA
0 vote202 views1 answer
Excel vba send HTTP POST to server
VBA
0 vote195 views1 answer
Vba add shape oval
VBA
0 vote234 views1 answer
How to enter Vbox manage commands
VBA
0 vote200 views2 answers
How to concatenate more than 40 lines in vba
VBA
0 vote224 views2 answers
Delete all controls from list of control vb.net
VBA
0 vote262 views1 answer
Vba excel do not recalculate before save
VBA
0 vote200 views1 answer
Excel text to columns line break
VBA