title: Fastest way to check if two ranges are equal in excel vba
body: <p>Imagine you have two sets of data and the number of rows and columns are the same. Now you want check if data in cells in one set is equal to data in cells with the same relative address in the other set. If thats true for all cells of a row, remove the row from both sets. I can code this very easily by comparing each cell and that's not good for large data sets. See code below for two columns where the two sets of data happen to be in the same sheet side by side with 300 in column offset between them.</p>
  
  <pre><code>Dim RngOb As Range
  Dim c As Range
  
  Range("A1", "B1").Select
  set RngOb = Range(Selection, Selection.End(xlDown))
  
  For Each c In RngOb.Rows
      If c.Cells(1,1).Value = c.Offset(0, 300).Cells(1,1).Value Then
          If c.Cells(1,2).Value = c.Offset(0, 300).Cells(1,2).Value Then    
              c.EntireRow.Delete
          End If
      End If
  Next
  </code></pre>
  
  <p>My actual data has more than 100 columns and different number of columns from day to day. I'm looking for a smart, fast way to do this for large data sets. I highly appriciate answers, feedback and criticism. :D</p>