title: Excel VBA How to Remove all the Duplicate rows based on column C
body: <p>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</p>
  
  <pre><code>Sub RemoveDupe()
  Dim rCell As Range 
  Dim rRange As Range 
  Dim lCount As Long 
  
  Set rRange = Range("C1", Range("C" &amp; 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) &gt; 1 Then 
              .EntireRow.Delete 
          End If 
      End With 
  Next lCount 
  End Sub
  </code></pre>
  
  <p>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?</p>