Macro Help Please

[Neverland]

Hi,

I was wondering if anyone could help me with a macro, haven't been able to find a solution so far.

I have 5 numbers '1', '2', '3', '4', '5' in cells a1-a5.

I want to find all the possible ways you can add 2 of these together.

I want the macro to type the output into column C:D.

So, for this example, the output would be:

1 in c1, 1 in d1
1 in c2, 2 in d2
1 in c3, 3 in d3
1 in c4, 4 in d4
1 in c5, 5 in d5
2 in c6, 1 in d6 and so on until we get to '5' in cX and '5' in dX.

One last thing, when it gets to the 1,000th row, id like to move the output to cells E:F.

Does anyone have any idea how to do this? I would be very grateful.

Thanks

 

[Boller]

http://www.mrexcel.com/forum/showthread.php?t=114280

 

[Neverland]

First of all, thanks. However, this defines array 1 & 2 as 'B' and 'S'. if there are a number of different characters, how could you go about it? I am going to have around 300 numbers. I may do it manually, but if theres a more efficient way of doing it, i wouldnt mind knowing.

 

[Boller]

http://www.google.com.hk/search?hl=...oogle+Search&meta=&aq=f&aqi=&aql=&oq=&gs_rfai=