/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 vote289 views1 answer
Excel run macro every 5 minutes
VBA
0 vote277 views1 answer
Vbnet dynamically change excel sheet name
VBA
0 vote298 views1 answer
Change form background image vb
VBA
1 vote293 views1 answer
S yyyy-MM-dd HH:mm:ss Short Date Local
VBA
5 votes316 views1 answer
Excel vba tool to help with refactoring code
VBA
0 vote297 views1 answer
Vba get workbook name
VBA
0 vote298 views1 answer
Excel vba calculate
VBA
31 votes391 views1 answer
Excel-vba how to convert a column number into an excel column
VBA
0 vote280 views1 answer
Vb net check if file exists
VBA
3 votes284 views1 answer
Excel vba export sheet as a csv without losing focus of my current workbook
VBA