/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 vote213 views1 answer
How to call gcd in vba
VBA
0 vote172 views1 answer
How to use VBA to add new record in MS Access?
VBA
0 vote255 views2 answers
VB
VBA
0 vote178 views1 answer
Vba collection contains
VBA
0 vote175 views1 answer
System.Runtime.InteropServices.COMException: 'Call was rejected by callee. (Exception from HRESULT: 0x80010001
VBA
0 vote181 views1 answer
Average vba
VBA
1 vote183 views1 answer
Excel vba How to determine if a date falls on the weekend?
VBA
0 vote171 views1 answer
Backspace key has stopped working visual studio
VBA
0 vote191 views1 answer
Visual stuiod not recognising desgined labels
VBA
0 vote225 views1 answer
Vba excel parser xml
VBA