第1个回答 2013-12-07
用函数很难实现,通过宏实现吧!
右击工具栏,选择“控件工具箱”,然后在工作表中画一个按钮,双击按钮输入以下代码:
Option Base 1
Const M As Integer = 40
Const N As Integer = 7
Private Sub CommandButton1_Click()
Dim i As Integer, a(M) As Integer, x As Integer
Do While i < N
x = Int(Rnd * (40 - 1) + 1)
If a(x) = 0 Then
a(x) = 1
i = i + 1
Cells(1, i) = x
End If
Loop
End Sub
然后在控件工具栏中选择“退出设计模式”,以后每次单击按钮,就可以在A1:G1产生不重复的数字。本回答被网友采纳