CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 12 of 12

Threaded View

  1. #1
    Join Date
    Jul 2004
    Posts
    2

    Question Permutations/Combinations Problem in VBA

    This is my first posting here so please bear with me if this question has been asked before. I did search the forums and didn't find anything in VBA that resolves pairs of combinations.

    Can someone help me with an elusive permutations/combinations problem? I want to generate a list of possible combinations of pairs of (sets of six) letters and numbers.
    The total set is made up of six letters and three numbers.

    For example:

    1 2 3
    A
    B
    C
    D
    E
    F

    The first set of six pairs would be:

    Set 1 = A1,B1,C1,D1,E1,F1
    Set 2 = A1,B1,C1,D1,E1,F2
    Set 3 = A1,B1,C1,D1,E1,F3
    Set 4 = A1,B1,C1,D1,E2,F1
    Set 5 = A1,B1,C1,D1,E3,F1
    Set 6 = A1,B1,C1,D1,E2,F2

    I would appreciate any code samples in VBA.

    Thanks very much in advance.
    Last edited by Jazzike; July 9th, 2004 at 08:38 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  





Click Here to Expand Forum to Full Width

Featured