Compile error HELP

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

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
 
Back
Top