Trying to understand more about arrays,,
I have values in cells A11:A19, so when I run:

Sub CreateAnArray()
Dim MyArray(9) As Long
Dim i As Integer
Dim R As Range
i = 0
Set R = Range("A11:A19")
For Each c In R
MyArray(i).Value = c.Value ' Bombing Here Compile error!!
i = i + 1
Next c
End Sub


WHY?
Thanks,,

Option Explicit
Sub CreateAnArray()
Dim MyArray(9) As Long
Dim i As Integer
Dim R As Range
Dim C As Range
i = 0
Set R = Range("A11:A19")
For Each C In R
MyArray(i) = C.Value ' Bombing Here Compile error!!
i = i + 1
Next C
End Sub



Jim May wrote:

Trying to understand more about arrays,,
I have values in cells A11:A19, so when I run:

Sub CreateAnArray()
Dim MyArray(9) As Long
Dim i As Integer
Dim R As Range
i = 0
Set R = Range("A11:A19")
For Each c In R
MyArray(i).Value = c.Value ' Bombing Here Compile error!!
i = i + 1
Next c
End Sub

WHY?
Thanks,,

--

Dave Peterson