|
楼上的附件,是根据你的说明写的,如果数据量较大,只是取一些随机数据的话,建议你用下面这段代码,运行速度较快,这是直接在宏内取随机数,而不是在单元格内取数据,这样能大大提高运行速度的,你可以对比选择一下。- Sub mydata1()
- Dim x, y, m, n, ar()
- Dim str As String
- str = InputBox("请输入运行的次数:", "数据输入")
- If str = "" Then Exit Sub
- n = Val(str)
- ReDim ar(1 To n, 1 To 6)
- For x = 1 To n
- For y = 1 To 6
- ar(x, y) = Application.WorksheetFunction.RandBetween(1, 10000)
- Next y
- Next x
- m = Sheet1.Cells(Rows.Count, 2).End(3).Row
- Sheet1.Cells(m + 1, 2).Resize(n, 6) = ar
- Z = Sheet1.Cells(Rows.Count, 2).End(3).Row
- Sheet1.Range("b4:g" & Z + 1).Sort key1:=Sheet1.[d3], order1:=xlAscending
- End Sub
复制代码 |
|