[VBA ] 用VBA要怎麼寫出所有可能的組合阿

[sdtty (低調低調)]

限制式 a1+a2+a3+a4=1

a1={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11組可行解

a2={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11組可行解

a3={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11組可行解

a4={0,0.1,0.2,0.3,0.4,0.5,0.6,0.7,0.8,0.9,1}-->共11組可行解


要怎麼用vba寫出所有可能的組合呢?

拜託各位高手了<(_ _)>

--

--
※ 發信站: 批踢踢實業坊(ptt.cc) 
◆ From: 140.134.72.45
→ PsMonkey:連題目都看不太懂
推 slalala:這是資料結構的問題 建議用迴圈
推 edwar:X1+X2+X3+X4=10 非負整數解數目: H(4,10)=C(13,3)=286