title: How to go through each column and remove duplicates in Excel (VB)
body: <p>I'm looking to go through 7776 columns of data and remove duplicates.</p>
  
  <p>I can't get remove duplicates to work with relative cell referencing.</p>
  
  <p>This works ...</p>
  
  <p>ActiveSheet.Range("B1:B31").RemoveDuplicates Columns:=1, Header:=xlNo</p>
  
  <p>but changing it to relative so I can iterate though the columns doesn't work.</p>
  
  <p>I tried to pass the cells into an array, then find duplicates and then return those values to a new sheet but same column position.</p>
  
  <p>Any help is much appreciated! I've been banging my head on a brick wall most of today!</p>
  
  <p>Lewis</p>