title: Find Duplicate Rows with VBA
body: <p>I need to identify duplicate rows in VBA (Note: a duplicate row implies equal values to the original row over all columns considered). I found a couple of programs to do this based on a certain column and I know duplicate rows can be found and deleted very quickly with <code>Range.RemoveDuplicates Method (Excel)</code> for whole rows, but that does not help me with the identification. Assume the following rows are given:</p>
  
  <pre><code>EE  10  12  13
  jk  56  AA  00
  BB  32  af  12
  21  CC  CC  fg
  as  DD  89  fg
  AA  67  45  vb
  fh  56  df  kl
  cv  fh  CC  34
  af  xv  DD  67
  EE  10  12  13
  </code></pre>
  
  <p>In this example, the first and the last row are to be identified (either returned in a function or marked in some type of colour). Note that I do not want to delete them, but rather save them on a new sheet, but that is not the problem. The problem is just the identification.</p>
  
  <p>With my real data I have about 30,000 rows, so performance is also quite important.</p>