CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2008
    Posts
    3

    creating combinations of values stored in arrays

    Hi All,
    This is more of a generic programming topi I guess, but I am trying to code up something in VB (newbie) for Excel.

    In a row of Excel, I have multiple comma separated values stored in each column.

    For ex:

    a,1 b,2,3 c ...

    I have data in 10 such columns.

    I have copied the comman seaparated values into individual arrays. i.e. one array per column.
    I need to loop through all these and create combinations of these values.

    My output should be

    a,b,c..
    a,2,c..
    a,3,c..
    1,b,c..
    1,2,c..
    1,3,c..

    How can I accomplish this? Please help. Thanks!

  2. #2
    Join Date
    Jan 2006
    Location
    Pearl of the orient
    Posts
    304

    Re: creating combinations of values stored in arrays

    Will that be random?

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