I have some issues to remove in an excel sheets my duplicates from a single Column (the first one). When i use the "RemoveDuplicates" function , i got some error " code 1004" . "total" is my worksheet and "rng" is define and set as a Range as you can see here :

```
With total
    Set rng1 = .Range("A2:B" & .Range("A" & .Rows.Count).End(xlUp).Row)
End With
    rng1.RemoveDuplicates

```