View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Harald Staff Harald Staff is offline
external usenet poster
 
Posts: 1,327
Default Distinct Data In Combo Box

"onedaywhen" skrev i melding
om...
If we were talking about 30,000 rows I'd dispute the 'very quick'
claim <g.


True. It was "quick" as in "fast written".

This slight amendment will give better performace:


Also true. That last For Each part was to demonstrate how to loop a
collection (for sorting purposes or whatever). Worth mentioning is that
collections are very quick and efficient, but they can be very memory
hungry.

Best wishes Harald
Followup to newsgroup only please