Goodday

Hope someone can help me with the following macro. This is what I hope to get achieved. Column A I have numbers repeat numbers aswell thats assigned to Column B Column B I have numbers 1-45 aswell thats assigned to Column A. In the following Macro what do I need to change so that the odd even get work out on column B instead of Column A as the range is set on Column A BUT very important Now for the tricky part


I have a target Sum that's my aim to get to an array Combination's in column F. My aim is to list all available combination's 3 evens 3 odds that's equaled to the target sum But the target sum must be worked out with 6 combination's from Column A to give me the result of 58. The answer I am hoping to achieve is 13 18 24 39 43 4 from Column B for an total of 3 odds 3 evens but the formula can list all combination's that's 3 odds 3 evens that's equals to 58. So the odds evens must be set with column B but the total 58 must be set with all available combination's 6 of them to equal 58. What do I need to change in the code to achieve the results ? Any help greatly appreciated.

Gman41

Sample attached