+ Reply to Thread
Results 1 to 15 of 15

Scrabble Game macro collections

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Scrabble Game macro collections

    I have a list of 7 letter words on a and 8 letter words on b

    I want macro to do the following

    list all similar by one vowel position any position

    See D and E as TRENAIL TREENAIL , if it finds next it should append at d2 and e2 and d3 and e3 and so on

    To work on unlimited rows range since , I have deleted many word , this list contains 10000+20000 words
    Attached Files Attached Files

  2. #2
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    here is another example , STEARIN STEARINE , for expected results list

  3. #3
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    here is another example , ESTRIOL OESTRIOL , for expected results list

  4. #4
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    here is another example , ESTRONE OESTRONE , for expected results list

  5. #5
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Thus for examples mentioned d and e would look as follows

    ESTRIOL OESTRIOL
    ESTRONE OESTRONE
    STEARIN STEARINE
    TRENAIL TREENAIL
    Last edited by makinmomb; 08-22-2017 at 07:28 AM.

  6. #6
    Forum Guru
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,729

    Re: Scrabble Game macro collections

    Maybe :
    Please Login or Register  to view this content.

  7. #7
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Very Awesome , thank you , Karendog , please same logic for seven letter words , for words like ANIMATE ANIMATI ANIMATO

  8. #8
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Even if the field go to 3 to 4 or 5 columns will do too

  9. #9
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Are there is one like that may fit to 5 columns on results

    HALLOED HELLOED HILLOED HOLLOED HULLOED
    Last edited by makinmomb; 08-22-2017 at 08:17 AM.

  10. #10
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Also same third macro for similars in eight letter words , same logic , not starting several threads of multiple requirements

  11. #11
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Keeping the thread open , sorted for the first macro

  12. #12
    Forum Expert
    Join Date
    06-12-2012
    Location
    Ridgefield Park, New Jersey
    MS-Off Ver
    Excel 2003,2007,2010
    Posts
    10,241

    Re: Scrabble Game macro collections

    This one takes about 5 mins took run, if time is not an issue.

    Please Login or Register  to view this content.

  13. #13
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Incase someone gets the time for part two of the macro , list summary of such ones

    ANIMATE ANIMATI ANIMATO
    HALLOED HELLOED HILLOED HOLLOED HULLOED

  14. #14
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    John yours unfortunately picks plurals and too slow , I have 6o,ooo rows

    That of Karendog skinned those rows at less than 1o seconds

  15. #15
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    Excel 2010
    Posts
    2,414

    Re: Scrabble Game macro collections

    Maybe I will just start a new thread

+ 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] Finding the scrabble wildcard
    By makinmomb in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-31-2017, 06:04 AM
  2. [SOLVED] Scrabble stop watch
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-18-2017, 01:24 PM
  3. [SOLVED] Tile tracker , for online scrabble tournament
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 05-01-2017, 09:39 AM
  4. [SOLVED] Scrabble hooks summary
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-10-2017, 10:04 AM
  5. scrabble hook macro
    By makinmomb in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-28-2016, 02:59 AM
  6. Collections within class module collections
    By AndyLitch in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2013, 06:00 AM
  7. [SOLVED] Game score without game being played
    By Sheila in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-17-2005, 07:06 PM

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