Loop through every combination in Array

Hi,
in attached file I made example of a Range method to find by country a combination of 2 values that add up to amount on the right.
However, Belgium doesn't get its Cell Addresses, because 138 is Sum of 3 values (E9, E10, E16).

I look for a looping mechanism, that would go through each 2-combination of values until it finds the result,
otherwise would continue with 3-combination, 4 .. up to all items combination necessary to find respective SUM.

Example:
A-B, A-C, A-D ..... A-Z
A-B-C, A-B-D ...A-B-Z ; A-C-D .. A-C-Z ...

I thought of using an Array, but don't know how.

[ATTACH=CONFIG]70345[/ATTACH]

Re: Loop through every combination in Array

Or maybe there is other way ?

Re: Loop through every combination in Array

Also posted here:
http://www.excelforum.com/exce…ru-every-combination.html

Re: Loop through every combination in Array

forum.ozgrid.com/index.php?attachment/70376/

A really impressive code. Thank you very much.
In this file, I slightly modified your syntax to suit the needs of the original file.

Have a nice day!