Hi friends,

I need a macro or formulas that replicate a line of equal numbers of cells
to another line after
Thanks

Rui

"jay dean" escreveu:

Hi,

Each cell in Range("A1:A100") contains an integer. I would like a macro
or function that will generate a list of all possible numbers in the
range that SUM up to 70 and place them in column C. The delimiter I'd
like to use for each solution is "\".

For example, column C could contain:
C1: 20 \ 50
C2: 60 \ 10
C3: 15 \ 35 \ 20
c4: 17 \ 33 \ 16 \4

.. and so on..

Any help would be appreciated.

Thanks
Jay



*** Sent via Developersdex http://www.developersdex.com ***