Sub RemoveDuplicates ()
ActiveSheet.Range("A:A").RemoveDuplicates Columns:=1, Header:=xlNo
' Without header
End Sub
Sub RemoveDuplicates ()
ActiveSheet.Range("A:A").RemoveDuplicates Columns:=1, Header:=xlYes
' With header
End Sub
ActiveSheet.Range("A:A").RemoveDuplicates Columns:=1, Header:=xlNo
' Without header
End Sub
Sub RemoveDuplicates ()
ActiveSheet.Range("A:A").RemoveDuplicates Columns:=1, Header:=xlYes
' With header
End Sub
No comments:
Post a Comment