View Single Post
  #26   Report Post  
Posted to microsoft.public.excel.programming
Alan Beban Alan Beban is offline
external usenet poster
 
Posts: 200
Default Sub to extract uniques from 200k data in xl03

Max wrote:
Alan, sorry, I just posted a response to your earlier reply which crossed
this. It **worked** and took only 15 sec to spit out the results !! Superb.


There's a bug in the SubProcedure abtest1 that you are using. If the
number of unique elements is an exact multiple of 65536, then in the
Select Case section of the code, y will equal 0 and the code will throw
an error. You need to modify the code to provide for this case.

Alan Beban