本帖最后由 diebianhai@ 于 2019-10-31 14:25 编辑
Sub dx8()
Dim arr(), arr1(1 To 100000, 1 To 4)
arr = Range("a1:d6")
Dim x, k
For x = 1 To UBound(arr)
If arr(x, 1) = "B" Then
k = k + 1
arr1(k, 1) = arr(x, 1)
arr1(k, 2) = arr(x, 2)
arr1(k, 3) = arr(x, 3)
arr1(k, 4) = arr(x, 4)
End If
Next x
Range("a15").Resize(k, 4) = arr1
End Sub
请问:
1.上面的例子中,arr在一开始的时候为什么不能写成dim arr(1 to 1000,1 to 4)?
2.arr1为什么一开始要写成arr1(1 To 100000, 1 To 4),而不能像arr一样,只写arr1或arr1()?
|