/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

4 votes200 views2 answers
Vba create folder if not exist
VBA
1 vote189 views1 answer
Sort using vba
VBA
0 vote170 views1 answer
Excel autofilter vba
VBA
22 votes251 views1 answer
Excel vba check if directory exists
VBA
0 vote127 views10 answers
Vba excel create event log
VBA
-1 vote199 views1 answer
How to correct a number to 2 decimal places in vba
VBA
0 vote202 views1 answer
Vba check if class implements interface
VBA
0 vote211 views1 answer
Vba search string position
VBA
5 votes193 views1 answer
Excel vba highlight cells using the hex color value within the cells
VBA
0 vote201 views1 answer
Vba array dimensions
VBA