Horje
vba code to remove duplicates from a column Code Example
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



3

Related
excel vba check if directory exists Code Example excel vba check if directory exists Code Example
excel vba wait Code Example excel vba wait Code Example
xl vba check for folder Code Example xl vba check for folder Code Example
excel vba function to convert column number to letter Code Example excel vba function to convert column number to letter Code Example
vba string to date Code Example vba string to date Code Example

Type:
 Code Example
Category:
 Coding
Sub Category:
 Code Example
Uploaded by:
 Admin
Views:
 10



 

Horje