+ Reply to Thread
Results 1 to 3 of 3

How to use CreateObject("System.Collections.SortedList") in VBA

  1. #1
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    136

    How to use CreateObject("System.Collections.SortedList") in VBA

    I have seen some people use this line of code below in various things like when handling arrays.
    CreateObject("System.Collections.SortedList")
    Can someone explain to me when we should use it and what it does exactly. I will also prefer web-links or references that can add to the explanation.
    Thanks for your time

  2. #2
    Forum Guru
    Join Date
    08-15-2004
    Location
    Tokyo, Japan
    MS-Off Ver
    2013 O.365
    Posts
    22,524

    Re: How to use CreateObject("System.Collections.SortedList") in VBA

    When extract the list of unique values sorted in ascending order.

    http://msdn.microsoft.com/en-us/libr...code-snippet-3

  3. #3
    Forum Contributor
    Join Date
    10-01-2013
    Location
    Houston
    MS-Off Ver
    Excel 2010
    Posts
    136

    Re: How to use CreateObject("System.Collections.SortedList") in VBA

    Jindon,
    Thanks a lot for the link. I am one of your big fans...and I have noticed that you have used it a lot in several scenarios.
    Thanks once more

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. CreateObject("Excel.Application") doesnt work in Office 365
    By c.vaibhav in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-30-2016, 08:00 AM
  2. Replies: 2
    Last Post: 01-03-2013, 04:32 PM
  3. CreateObject("System.Collections.ArrayList")
    By pike in forum Tips and Tutorials
    Replies: 4
    Last Post: 07-09-2012, 11:49 AM
  4. Eliminating "double" numbers from a sortedlist
    By khank in forum Excel General
    Replies: 8
    Last Post: 03-25-2011, 09:58 AM
  5. Merging a "physical count" to a "system on-hand"
    By raharms in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-20-2010, 04:43 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1