+ Reply to Thread
Results 1 to 2 of 2

Range to array, then check to see if the array contains a string

  1. #1
    Registered User
    Join Date
    07-25-2012
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Range to array, then check to see if the array contains a string

    Hey
    I'm making a word game.
    At the moment I have a large dictionary sorted through columns AA to ZZ. 173000 words. To check if a word is true I get the first 2 letters of the string, which references me to the column. Eg the word help will scan through the column "HE". 1 of the columns "RE" is over six thousand rows, so it takes about a quarter f a second to scan. Ideally I would like it faster.

    I know I can scan it faster if I use an array, although I am pretty clueless when it comes to ten.

    If I put all the words into column "A" (173000 odd lines) could someone please help me with code to add this column to an array.

    Then I wish to check a string variable against the array, and then find out if it's in there.

    Everything is done in uppercase so that's not a problem.

    Many thanks for your help.
    Last edited by yeahyeahyeah; 09-17-2012 at 10:29 AM.

  2. #2
    Registered User
    Join Date
    07-25-2012
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    16

    Re: Range to array, then check to see if the array contains a string

    Never mind I figured it out

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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