vba code to remove duplicates from a column vba code to remove duplicates from a column

The solution for “vba code to remove duplicates from a column vba code to remove duplicates from a column” can be found here. The following code will assist you in solving the problem.

Get the Code! 
Sub removeDuplicate()

 ‘removeDuplicate Macro

 Columns(“A:A”).Select

 ActiveSheet.Range(“$A$1:$A$117”).RemoveDuplicates Columns:=Array(1), _

 Header:=xlNo

 Range(“A1”).Select

 End SubSub 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

Thank you for using DeclareCode; We hope you were able to resolve the issue.

More questions on [categories-list]

Similar Posts

excel vba last row excel vba last column with data excel vba first and last row and column in range

Bym0nxt3r

The solution for “excel vba last row excel vba last column with data excel vba first and last row and column in range” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]

VBA CELL equal

Bym0nxt3r

The solution for “VBA CELL equal” can be found here. The following code will assist you in solving the problem.Thank you for using DeclareCode; We hope you were able to resolve the issue. More questions on [categories-list]