title: Autofilter using array as criteria max size
body: <p>So this is kinda a weird one but:</p>
  
  <p>I have an excel sheet with a few hundred thousand rows of customer data. I have a sheet with 70,000 names and addresses to remove from the bigger sheet.</p>
  
  <p>What I've done before with VBA is combine the names and addresses into one column (on both sheets) and then I put all of the combination name+address cells into an array, then use the <code>autofilter</code> with the array of names + addresses. that shows me all of relevant names + addresses.</p>
  
  <p>However I've never had 70,000 rows to get rid of, and I've discovered that the max number of values you can use in filtering with an array is 65536. I imagine this has to do with the fact that 65536 is the biggest int you can have, and the largest number represented by 16 bits, etc... </p>
  
  <p>does anyone know how I can use the autofilter with an array of values that is bigger than 65536? </p>