|
请帮助编写添加数据代码
本帖最后由 那么的帅 于 2013-2-18 11:27 编辑
- Private Sub co13_Click()
- Dim x, y As Integer, arr, rg1, rg2
- rg1 = Application.CountA(Range("a1:n1"))
- x = Range("a1:n1").SpecialCells(xlCellTypeBlanks).Count
- K = 5 - rg1
- Do While K > 0
- s = Int(Rnd * 13 + 1)
- If Cells(1, s) = "" Then
- Cells(1, s) = s
- K = K - 1
- End If
- Loop
- End Sub
复制代码
|
|