/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

25 votes553 views3 answers
String to date vb
VBA
0 vote288 views1 answer
Excel vba protect worksheet without password
VBA
2 votes213 views1 answer
Vba split string
VBA
0 vote229 views1 answer
Dynamically change drop down list visual basic
VBA
0 vote217 views1 answer
Vba border weight
VBA
0 vote269 views1 answer
Excel vba protect sheet
VBA
0 vote220 views1 answer
System.InvalidOperationException: 'Row associated with the currency manager's position cannot be made invisible.
VBA
1 vote225 views1 answer
Excel vba Refreshing all pivot tables in workbook
VBA
1 vote228 views1 answer
Excel vba autofit
VBA
0 vote232 views1 answer
Convert unix to date vba
VBA