View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BigRog BigRog is offline
external usenet poster
 
Posts: 2
Default delete dupes in column

All,
I have a worksheet with < 200 rows of data (6 Cols). I need to eliminate the
entire row of data if Column "B" contains any duplicate entries. I prefer
using VBA, as the rest of the project uses it almost exclusively. I have
tried looping thru the entire table for each new value in the column, but it
takes much too long and results in buffer overruns.

Thanks,
BigRog