two dimensional array

[yosegmail]

vba procedure that use For/Next loops
to store the contents in range A1:E5 to a two dimensional Array? and three dimensional Array?

 

[offthelip]

For a two dimesional array:

Arrayname=Range("A1:E5")

 

[yosegmail]

yes but i may not be able to call say when i want it to
Arraynames(2)???

i came this far

Const I = 5
Const J = 5
Dim myArray(I, J) As Integer

For Each t In Range("a1:e5")

Stop
Next


say after myArray(1,2) should give the values
in the range specifed

 

[offthelip]

I am not at all clear what you are trying to do.
the code i posted loads all the values in the range A1 to A5 into the array Arraynames,
you can loop through with code like :

For i = 1 to 5
 msgbox(arrayname(i,1)
next i

you can refer to the value in A2 with code such as:

a2value=Arrayname(2,1)

 

[yosegmail]

thanks