+ Reply to Thread
Results 1 to 5 of 5

Contains in arrayList VBA

  1. #1
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Contains in arrayList VBA

    Hi,

    i am using code:

    Please Login or Register  to view this content.
    contains method should know that "Input" is within Array but nothing is happening.
    Why?

    Best,
    Jacek

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

    Re: Contains in arrayList VBA

    You can not add each element in an array to an ArrayList in that way.
    What you are doing is adding whole Array to the list.
    Please Login or Register  to view this content.
    Will tell you what you added.

  3. #3
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Contains in arrayList VBA

    thank you jindon.

    Ok so it is no possible to find string within first item of arraylist here?

    Jacek

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

    Re: Contains in arrayList VBA

    No,...

    Dictionary, ArrayList, SortedList will not accept each element to add when Array is added in vba.
    So, if you add each element individually to the object, you can.

  5. #5
    Forum Contributor
    Join Date
    01-16-2014
    Location
    Poland
    MS-Off Ver
    Excel 2016-365
    Posts
    2,940

    Re: Contains in arrayList VBA

    thank you!

    Jacek

+ 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. [SOLVED] Join 3 arrays/arraylist/ranges and pass them to dictionary
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-09-2018, 07:49 AM
  2. [SOLVED] Best object (array, dictionary, arraylist etc) to sort values in columns
    By jaryszek in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 04-07-2017, 08:28 AM
  3. Replies: 2
    Last Post: 08-22-2014, 03:55 AM
  4. Pasting a big range of values from an arraylist to a worksheet
    By chrissy92 in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 05-28-2013, 06:02 PM
  5. CreateObject("System.Collections.ArrayList")
    By pike in forum Tips and Tutorials
    Replies: 4
    Last Post: 07-09-2012, 11:49 AM
  6. Please look at my VBA ArrayList custom class. Feedback is appreciated!
    By drinkmorecrabjuice in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 12-31-2011, 01:01 AM
  7. ArrayList
    By noobieNeedHelp in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-28-2009, 05: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