|
本帖最后由 incrediblesky 于 2015-7-10 17:14 编辑
qh8600 发表于 2015-7-10 16:23
楼主试试 - Sub demo()
- Dim rng As Range, ar(1 To 15, 1 To 1), n
- For Each rng In Range("b1:d5")
- If rng.Interior.ColorIndex = 6 Then
- n = n + 1
- ar(n, 1) = rng.Value
- End If
- Next
- Range("a1").Resize(n, 1) = ar
- End Sub
复制代码 ar(1 To 15, 1 To 1)这个虽然是二维数组,但也可看成一维数组,我改成ar(1 To 15)以下代码,为什么就不行了呢- Sub demo()
- Dim rng As Range, ar(1 To 15), n
- For Each rng In Range("b1:d5")
- If rng.Interior.ColorIndex = 6 Then
- n = n + 1
- ar(n) = rng.Value
- End If
- Next
- Range("a1").Resize(n, 1) = ar
- End Sub
复制代码 |
|