read array of values to generate a list of combinations

Hello,

I am trying to use this code to generate a list of combinations. As highlighted in first red, this code takes the input values separated by commas and I need to type manually. If I want to read these values which are in a Sheet1 in Range("A1:G1"). How do I modify? Also, as highlighted in the second red, the results of each combination is listed in each cell separated by commas. How do I modify the code so that each value of a combination is listed in separate cells in a row. Thanks for your help.

Please Login or Register  to view this content.

I am sorry that I could not understand the second part. Can you elaborate a bit more? Thanks.

Thanks.

I understood the offset part. Just the loop part was a bit confusing. I tried to implement what you just said but am getting an error. I guess am making a mistake in the loop.