Change a variable every time a variable changes

[ineedhalp]

Might be hard to explain but I will try. So I'm doing combinations that consist of 5 things. Now the combinations can easily be done with for and next. BUT I want to write down each different combination in a different column. Now I can't figure this out. Every time an item changes, I want the column to be changed to the next one. My current code looks basically like this:

For item1 = 2 To itemarv
    For item2 = 2 To itemarv
        For item3 = 2 To itemarv
            For item4 = 2 To itemarv
                For item5 = 2 To itemarv
                Next item5
            Next item4
        Next item3
    Next item2
Next item1

Now how could I make the code change the column variable each time a "next" command is given?

 

[ineedhalp]

Please halp me, it can't be that hard. I'm kind of in a hurry. Sorry.

 

[ineedhalp]

Nevermind, got it!

 

[Norie]

There is no column variable.

 

[ineedhalp]

Sorry, still didn't get it. Column variable isn't included in the code I provided. The point is I have to change a variable every time the "next" command is used.

//Nevermind, got it for real now. No help needed anymore.

 

[Norie]

Change it to what after which 'next', there are a few 'next' statements.