title: First value twice when using unique filtering (VBA)
body: <p>I have made a very simple Visual Basic script, which uses the advanced filter function in Excel, to copy unique values from a column in one sheet, to a column in a different sheet. It works fine on all values, except the first which appears twice. Can anyone tell me the reason for this glitch? I tried using the filter manually, with the same result.</p>
  
  <pre><code>Sub getUniqueRuns()
  
      Sheets(2).Range("C2:C65536").AdvancedFilter Action:=xlFilterCopy, 
      CopyToRange:=Sheets(5).Range("A2"), Unique:=True
  
  End Sub
  </code></pre>