Results 1 to 13 of 13

number combo generator?

Threaded View

  1. #11
    Registered User
    Join Date
    01-20-2004
    Location
    Western NY
    Posts
    99
    attached is a revised version of the code to handle the situation as you redefined it. The code is written to handle only 5 columns but does not care how many numbers are in each column. Given the very large number of combinations possible, the procedure no longer displays individual combinations. Rather it simply writes them to other worksheets. The code is presently set up to write up to 15000 combinations to each of 5 worksheets (the upper limit for rows in a worksheet is 65000). The combinations are written to "Combo" worksheets as a sequence of 5 numbers, each number in an individual cell.

    Let me know if this works.

    MWE
    Attached Files Attached Files

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