當前位置:編程學習大全網 - 電腦編程 - EXCEL裏的編程問題,有關組合

EXCEL裏的編程問題,有關組合

A1:H1分別為妳要進行組合的8個數

運行以下宏,結果在A2:A57

Sub combinxx()

n = 2

For i = 1 To 4

For j = i + 1 To 5

For k = j + 1 To 6

For l = k + 1 To 7

For m = l + 1 To 8

Range("a" & n) = Cells(1, i) & "," & Cells(1, j) & "," & Cells(1, k) & "," & Cells(1, l) & "," & Cells(1, m)

n = n + 1

Next

Next

Next

Next

Next

End Sub

  • 上一篇:燕山大學車輛工程師很少嗎?
  • 下一篇:KwWwbKit.exe停止工作是什麽意思?
  • copyright 2024編程學習大全網