/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

5 votes363 views1 answer
Xl vba double quotes in string literal
VBA
0 vote370 views1 answer
Excel last used row
VBA
31 votes503 views1 answer
Vba how to convert a column number into an Excel column
VBA
1 vote355 views1 answer
Excel vba compare 2 rows
VBA
0 vote335 views1 answer
Windows Presentation Foundation dark title bar
VBA
0 vote345 views1 answer
Compare dates vb
VBA
0 vote380 views1 answer
Excel vba first column in range
VBA
0 vote350 views1 answer
Vba option button selected
VBA
3 votes378 views1 answer
Excel vba make long from two shorts
VBA
0 vote347 views1 answer
Vba horizontalalignment
VBA