怎么用VBA在EXCEL中解决排列组合的问题答:Cells(9, c) = Cells(2, a2)Cells(10, c) = Cells(3, a3)Cells(11, c) = Cells(4, a4)Cells(12, c) = Cells(5, a5)Cells(13, c) = Cells(6, a6)c = c + 1
用excel里的宏实现 排列组合答:1) = arr(a, 1) arr1(i, 2) = arr(b, 1) arr1(i, 3) = arr(c, 1) arr1(i, 4) = arr(d, 1) arr1(i, 5) = arr(e, 1) arr1(i, 6) = arr(f, 1) Next f Next e Next d Next c Next b Next a 建议你直接运行代码理解吧(如从1~8取6,只有28个结果,相...