|
楼主 |
发表于 2011-8-17 03:09
|
显示全部楼层
第1组宏
Sub 簿4()
Dim arr, i&, n&
arr = Range("A1:E44444") ' & Cells(2, 2).End(4).Row)
n = UBound(arr)
Columns("k").ClearContents
[k1].Resize(n - 2, 1) = Application.Index(arr, , 3)
End Sub
Sub 簿666666()
Dim arr, i&, n&
arr = Range("A1:E666666") ' & Cells(2, 2).End(4).Row)
n = UBound(arr)
Columns("k").ClearContents
[k1].Resize(n - 2, 1) = Application.Index(arr, , 3)
End Sub
第2组宏
Sub 一维数组()
Dim i&, n&
Dim arr1(0 To 44444)
n = 44445
For i = 1 To 44445
arr1(i - 1) = i
Next i
Columns("N").ClearContents
[N1].Resize(n - 2, 1) = Application.Transpose(arr1)
End Sub
Sub 一维数组66666()
Dim i&, n&
Dim arr1(0 To 66666)
n = 66667
For i = 1 To 66667
arr1(i - 1) = i
Next i
Columns("N").ClearContents
[N1].Resize(n - 2, 1) = Application.Transpose(arr1)
End Sub |
|