В одной случае не работает, во втором работает почему ?
Sub test1()'Не работает
Dim rng As Range, rng1 As Range, rng2 As Range, arr, i&
ReDim arr(2)
For i = 0 To 2
Set rng = Range("A" & 1 + i & ":C" & i + 1)
arr(i) = rng
Next i
arr(2).Interior.Color = 65535
End Sub
Sub test2()'Работает
Dim rng As Range, rng1 As Range, rng2 As Range, arr, i&
Set rng = Range("A1:C1")
Set rng1 = Range("A2:C2")
Set rng2 = Range("A3:C3")
arr = Array(rng, rng1, rng2)
arr(2).Interior.Color = 65535
End Sub
*22757*
Sub test1()'Не работает
Dim rng As Range, rng1 As Range, rng2 As Range, arr, i&
ReDim arr(2)
For i = 0 To 2
Set rng = Range("A" & 1 + i & ":C" & i + 1)
arr(i) = rng
Next i
arr(2).Interior.Color = 65535
End Sub
Sub test2()'Работает
Dim rng As Range, rng1 As Range, rng2 As Range, arr, i&
Set rng = Range("A1:C1")
Set rng1 = Range("A2:C2")
Set rng2 = Range("A3:C3")
arr = Array(rng, rng1, rng2)
arr(2).Interior.Color = 65535
End Sub
*22757*
Спасибо |
---|
Mail: В профиле Skype: В профиле |