I am fairly new in Excel vba, What i am trying to do here is, 
Remove all the duplicate rows based on values in Column C. so whenever column c have duplicate values it will remove the entire row. So far i have this

```
Sub RemoveDupe()
Dim rCell As Range 
Dim rRange As Range 
Dim lCount As Long 

Set rRange = Range("C1", Range("C" & Rows.Count).End(xlUp)) 
lCount = rRange.Rows.Count 

For lCount = lCount To 1 Step -1 
    With rRange.Cells(lCount, 1) 
        If WorksheetFunction.CountIf(rRange, .Value) > 1 Then 
            .EntireRow.Delete 
        End If 
    End With 
Next lCount 
End Sub

```

but here it's leving the first value, i want to remove that one too. Only rows will be remaining whom did'nt have any duplicates or unique ones.
any help?