+ Reply to Thread
Results 1 to 3 of 3

6 Number Combination

  1. #1
    Registered User
    Join Date
    01-03-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    35

    6 Number Combination

    Hi,
    I copied this VBA code from a search to help with 6/49 lotto. It is suppose to do the following:
    It allows an input (in Column B)of an x set of numbers (e.g. 1,2,3,4,7,0,42,34,12, etc.)
    and it should give you all possible 6 number combinations (e.g. 3,7,12,34,1,2) and so forth.
    When i run it, it gives mismatch errors.
    Can anyone help me figure it out. Or is it better to start from scratch?
    Thanks



    Please Login or Register  to view this content.
    Last edited by shart2k12; 01-13-2013 at 10:59 AM.

  2. #2
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: 6 Number Combination

    from mr excel where this code was posted
    http://www.mrexcel.com/forum/excel-q...binations.html
    an amendment was made the code is missing 2 lines at the top it should read
    Please Login or Register  to view this content.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    01-03-2013
    Location
    HK
    MS-Off Ver
    Excel 2010
    Posts
    35

    Re: 6 Number Combination

    Your help is highly appreciated.
    it still stops at :
    Please Login or Register  to view this content.

  4. #4
    Forum Guru martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: 6 Number Combination

    not when i run it

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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