Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() 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 *** |