+ Reply to Thread
Results 1 to 4 of 4

Problems with Myrna Larson code for Combinations and Permutations

  1. #1
    Registered User
    Join Date
    02-19-2013
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    3

    Problems with Myrna Larson code for Combinations and Permutations

    I have been trying to work with Myrna Larson code, and I have updated

    If N > Cells.Count to

    If N > Cells.CountLarge

    for excel 2010, I'm using this data for Combinations and Permutations -

    alphabets - A-Z = 26

    numbers - 0-9 = 10

    and special characters . < ( + ! $ * ; - / > ? : # = ~ { } = 18
    total 26+10+18 = 54

    And I'm fishing for 3/4 and 5 character permutations/combinations of this, which should equal to 54*54*54 = 157,464 (for 3 character) combinations, now when I run the macro, I get the following error -

    Run-time error '1004':
    Application-definted or object-defined error.

    And in a new excel sheet I get data adding upto 26231 Combinations if I run C in A1, or 145,962 Permutations if I run with P in A1.

    I was wondering if anyone knows whats going wrong here, I have never programmed in VBA, and any help would be great.

    Thanks!

  2. #2
    Forum Moderator Leith Ross's Avatar
    Join Date
    01-15-2005
    Location
    San Francisco, Ca
    MS-Off Ver
    2000, 2003, & 2010
    Posts
    23,258

    Re: Problems with Myrna Larson code for Combinations and Permutations

    Hello I_max2k2,

    Welcome to the Forum!

    You should provide links to previous posts when you reference them. Since you are new, I have added the link in this post.

    For Those who are interested here is link to the original post and code...
    Link to the Original Code by Myrna Larson
    Sincerely,
    Leith Ross

    Remember To Do the Following....

    1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.
    2. Thank those who have helped you by clicking the Star below the post.
    3. Please mark your post [SOLVED] if it has been answered satisfactorily.


    Old Scottish Proverb...
    Luathaid gu deanamh maille! (Rushing causes delays!)

  3. #3
    Registered User
    Join Date
    02-19-2013
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Problems with Myrna Larson code for Combinations and Permutations

    Thank You, I was not aware, I'll keep it in mind.

    Has no one else had this issue?

  4. #4
    Registered User
    Join Date
    02-19-2013
    Location
    America
    MS-Off Ver
    Excel 2010
    Posts
    3

    Re: Problems with Myrna Larson code for Combinations and Permutations

    I'd absolutely appreciate any help guys.

    Thanks!

+ 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