**Alex**,

Exactly.Alexafjb said:So I guess now, to reduce the DN's down it's just a matter of Reverse Engineering the Module with more "For/Next" loops and "MyArray()"s, and of course, reducing some code also.

Have a go at adjusting theAlexafjb said:A thought occurred to me late last night, right at the edge of sleep!

In Column B "Excluding DN Numbers" 1-49 is Generated because of users input at E2 "Total Numbers Drawn From=".

Do you know of a formula/coding method that would allow 1, & or 2, Decades to be removed from the calculation pool?

I.E. No teens or say no 30's.

The module would still run the same as it does now, Just no Teens or 30's would be used to calculate out the "Combination Sum Total".

**Formula**with an

**If...Then**statement(s) or setting up a

**VBA Function**that you can apply an

**If...Then**statement(s) to.

It will probably be best to get this sorted

**BEFORE Reverse Engineering the Module**. This way it will make it a lot easier to create the other

**FOUR Modules**for

**DN1, DN2, DN3, & DN4**.

I will have a think about this and maybe do something on it later or tomorrow.

Keep up the good work .

BTW, the

**Excluding DN Numbers**is an

**Array**formula and therefore needs to be entered using

**Ctrl+Shift+Enter**before it is copied down.

You also need to reset the calculation method to

**Automatic**!

To get the colours the same,

**HIGHLIGHT**the cells

**D6:E6**and drag down, then change the

**DN4**to

**DN5**.

Regards,

PAB

-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-∏-

12:45, restate my assumptions.

Mathematics is the language of nature.

Everything around us can be represented and understood through numbers.

If you graph the numbers of any system, patterns emerge. Therefore, there are patterns everywhere in nature.