title: Delete Row from Array
body: <p>I am trying to go through an array to find duplicate entries in a single column of that array and delete the entire row. </p>
  
  <p>I am getting figuring out <code>rangeStart</code>, <code>rangeEnd</code>, and <code>lastrow</code> above this and that part is working fine.</p>
  
  <pre><code>data = Range(rangeStart, rangeEnd)
  
  For i = lastrow - 1 To 2 Step -1
      If data(i - 1, x) = data(i, x) Then
          'Delete data(i)
      End If
  Next
  </code></pre>
  
  <p>Any help with this would be awesome!</p>