/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

0 vote178 views2 answers
Checking and changing system volume vb.net
VBA
5 votes168 views1 answer
Excel vba low word from Long Integer
VBA
0 vote119 views1 answer
Vba set vs dim
VBA
1 vote164 views1 answer
Vba login website
VBA
0 vote150 views1 answer
How to set location and size of new from vb
VBA
2 votes113 views2 answers
Vba exit loop
VBA
0 vote165 views1 answer
Vba range clear formatting
VBA
2 votes179 views1 answer
Vba round number
VBA
0 vote173 views1 answer
Excel vba textbox forecolor disabled
VBA
1 vote126 views1 answer
Vba listindex select multiple items vba
VBA