Here is what I am trying to do. I want to put a set of parameters within cells a1:a4. Here is what they would say:

a1 = beginning number
a2 = ending number
a3 = numbers in each
a4 = repeating/non repeating?

So for example, if I wanted to return every possible combination of 5 numbers from numbers 1-36 and not repeating, I would put the following:

a1 = 1
a2 = 36
a3 = 5
a4 = non repeating

I would like it to return every possible combination in columns C-G. In this example, it should return 376,992 combinations. I once had a VBA formula which did this, but I haven't been able to find it again, so I know there is a formula out there that can do this. Can anyone help me out with this? Thanks!!!!!