VBA: questions about working with arrays

[BIGTONE559]

Greetings,

I'm trying to learn how to work with arrays. in this sample that i wrote i keep receiving an error at the "Msgbox MyArray(i)" line. the goal is to have the msgbox cycle through all of the values in the array. the error is "Subscript out of Range"

Sub Sample()
Dim i As Integer


Dim MyArray() As Variant
MyArray = Range("MyDates")
For i = 1 To UBound(MyArray)
MsgBox MyArray(i)
Next i

End Sub

All help is appreciated.

 

[BIGTONE559]

ok i've reached another stumbling block. upon trying to have a value entered into a cell i receive an application or object defined error.

e.g.

Worksheets("Test").Range(Cells(1, 2)).Value = myarray(1, 1)

if i write the line:

msgbox MyArray(1,1)

i receive the msgbox with 05/21/2012 however i cannot get this value in a cell????


WHY NOT?????

 

[BIGTONE559]

ok i've reached another stumbling block. upon trying to have a value entered into a cell i receive an application or object defined error.

e.g.

Worksheets("Test").Range(Cells(1, 2)).Value = myarray(1, 1)

if i write the line:

msgbox MyArray(1,1)

i receive the msgbox with 05/21/2012 however i cannot get this value in a cell????


WHY NOT?????

i am sooooooooooooooooo dumb!!!!!!!!!!!!! i noticed that i wasn't defining the range properly. . .

. . .