CreateObject("System.Collections.ArrayList")

  • doctored examples



    thats cool no loops

  • Re: CreateObject("System.Collections.ArrayList")


    Thats just totally awesome... thx Pike. I'll have to have a play with that later today. I would feel almost bad using it though... seems like taking a short cut and forgetting about a lot of what I learned with REDIMing :-D

    Check out our new reputation system. Click on the Like button under the post!
    _______________________________________________

    [SIZE=8px]There are 10 types of people in the world. Those that understand Binary and those that dont.


    Why are Halloween and Christmas the same? Because Oct 31 = Dec 25...


    The BEST Lookup function of all time


    Dynamic Named Ranges are your bestest friend[/SIZE]
    _______________________________________________

  • Re: CreateObject("System.Collections.ArrayList")


    Big fan of jindon and follow his posts and that’s where i first observed its benefits
    kyle123 enlighten to toarray(), now if i can just figure out how to add a range, IList or ICollection with out looping!

  • Re: CreateObject("System.Collections.ArrayList")


    these may also be helpful


  • Re: CreateObject("System.Collections.ArrayList")


    and of course


    sortedlist


  • Re: CreateObject("System.Collections.ArrayList")


    few more methods


  • Re: CreateObject("System.Collections.ArrayList")


    Did you ever manage to get an array in without looping?


    I think I've made my mind up that you can't since the array list is just a collection, though I'd be very happy for you to show me the error of my ways ;)

  • Re: CreateObject("System.Collections.ArrayList")


    passing ArrayList directly to array no loop

  • Re: CreateObject("System.Collections.ArrayList")


    replace item in array with .array() () and workable GetRange


    Copyto() ...eludes ??

  • Re: CreateObject("System.Collections.ArrayList")


    here is a few more CreateObject("System.Collections.ArrayList") methods that you can possibly use

    Code
    1. .IndexOf_3 ("A")' Last occurrence index in arraylist
    2. .Sort_2 (CreateObject("System.Collections.CaseInsensitiveComparer"))
    3. .Sort_3(2,3,nothing) 'Index, Count, Nothing
    4. .Sort_3(2,3,CreateObject("System.Collections.CaseInsensitiveComparer")) 'Index, Count, Comparer



    and CreateObject("System.Random")


  • Re: CreateObject("System.Collections.ArrayList")


    few more

    Code
    1. .BinarySearch_2(Value)
    2. .BinarySearch_3(value, CreateObject("System.Collections.CaseInsensitiveComparer")
    3. .BinarySearch(index, count, value, Nothing)
    4. .BinarySearch(index, count, value, CreateObject("System.Collections.CaseInsensitiveComparer"))


    interesting that they can be set up store two billion items!

  • Re: CreateObject("System.Collections.ArrayList")


    example of an ArrayList of ArrayList

  • Re: CreateObject("System.Collections.ArrayList")


    Little more information on using CreateObject("System.Random") class methods and discriptions. Translated by Google Translate from japanese to english
    http://tokidokidokin.com/2011/…%82%92%E4%BD%BF%E3%81%86/


    Next method - Return a random number greater than or equal to 0
    Next_2 method - will return a random number within a specified range
    Next_3 method - Returns a random number greater than or equal to 0 less than the maximum value that you specify
    NextDouble method - will return a random number between 1.0 and 0.0

  • another system collectons