Oops sorry. How are you deciding which combinations go in which cells? Is
there a method? It appears you are cycling through C, then B, then A. In
which case, you would be using a nested For loop.

Sub Loops
OutputCell=1

For A=1 to 3
OutPutA=cells(A,1).value & ""
For B=1 to 3
OutPutB=cells(B,2) .value & ""
For C=1 to 3
OutPutC=cells(C,3).value & ""
FinalOutPut=OutPutA & OutPutB & OutPutC
cells(OutputCell,4).value=FinalOutPut
OutputCell=OutputCell+1
Next C
Next B
Next A

End Sub

That should do the trick based on the initial posting.


"joel" wrote:


Re-Read the request. the results isn't one formula per row, the user
wants every combination.


--
joel
------------------------------------------------------------------------
joel's Profile: 229
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=161009

Microsoft Office Help

.