Combination of Number Issue

[hksharmaa]

Hi All,

I have an issue. I have 4 Numbers from 1 to 4.
Minimum Colum will be 2 and Max. column should be 8
Now i a want all different combinations of these numbers to give sum of 8. The numbers can repeat in a column.
The highest number which i can plot in any column should be less than equal to 4 and minimum should be 1.



Like 1+1+1+1+1+1+1+1=8(8 Coulumns Max.)
1+1+1+1+1+1+2 =8
4+4 =8(2 Columns Min.)
1+2+3+2 =8
4+1+1+1+1 =8

Is there an method??
Please help.

[NoSparks]

Now i a want all different combinations of these numbers to give sum of 8

1+1+1+1+4=8
1+1+1+4+1=8
1+1+4+1+1=8
1+4+1+1+1=8
4+1+1+1+1=8

How many different combinations is this ?

[Beamer]

I got 110 combinations

Maybe I misread

[Beamer]

oops, sorry. I saw the duplicate post and followed back to this via OP's profile.
Didn't notice that it was a VBA question.