- Sub 数组循环()
- Dim arr, i&, j&, brr()
- t = Timer
- arr = Sheets("数据表").UsedRange.Value
- For i = 1 To UBound(arr)
- For j = 1 To UBound(arr, 2)
- If Len(arr(i, j)) Then
- n = n + 1
- ReDim Preserve brr(1 To n)
- brr(n) = arr(i, j)
- End If
- Next
- Next
- Sheets("结果表").Cells(1, 1).Resize(n, 1) = Application.Transpose(brr)
- MsgBox "结果表已完成,用时:" & Format(Timer - t, "0.00") & "秒"
- End Sub
复制代码 |