Array list writing to an Array of 'scattered cells' ?
How to copy F1:F5 values to a range of scattered cells.
And, can you copy a range of scattered cells to another unlike range of scattered cells?
Howard
Option Explicit
Option Base 0
Sub Copy_Array()
Dim FromArray(5) As Variant
Dim ToArray(5) As Variant
Dim i As Integer
FromArray = Range("F1:F5") ' fails here- 'can't assign to array
ToArray = Range("A1,B2,C3,D4,E5")
For i = LBound(FromArray) To UBound(FromArray)
ToArray(i) = FromArray(i)
Next i
End Sub
|