/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 vote335 views1 answer
VB Error Code BC30201
VBA
0 vote361 views1 answer
Excel vba set cell value to empty
VBA
0 vote337 views1 answer
Get current year vb
VBA
0 vote323 views1 answer
Find the name of the last excel sheet vb
VBA
0 vote369 views1 answer
Excel web scraping
VBA
5 votes328 views1 answer
Excel vba how to unit test vba code
VBA
0 vote360 views1 answer
Como ler subitem de um array em json usando vbnet
VBA
8 votes452 views1 answer
Vba make a short integer from two bytes
VBA
0 vote336 views1 answer
Excel text to columns line break
VBA
2 votes346 views1 answer
Vba file from path
VBA