Selecting Second Array in Two dimensional array

[vepoyoke]

Hi..
I have two dimensional array named "ARRAY", the value of each element are:
(1,1) = 50
(1,2) = 70
(1,3) = 100

(2,1) = 30
(2.2) = 40
(2,3) = 45

i just want to print the value to the range for example a1:a3

if i code it like this

Please Login or Register  to view this content.

will give value of 50 , 70, 100 in a1 to a3 (first array)

how should I code it so in a1 to a3 I will print 30, 40 and 45 (second array) ???

if I code it

Please Login or Register  to view this content.

it won't work

please help..
thanks

[Andy Pope]

I think your array or the description of the output is incorrect.
If I use your example the contents of A1:A3 would be 50, 30, #Value

Try this

Please Login or Register  to view this content.

[Norie]

Try this.

Please Login or Register  to view this content.

PS This doesn't not show the values as you indicate.

Please Login or Register  to view this content.

It shows 50,30,#N/A in A1:A3.

[vepoyoke]

thanks Andy Pope and Norie!!!

using application.index(array,2) solved the problem..

yes i made a mistake it should be

Please Login or Register  to view this content.

that should be returned 50 , 70, 100 values

will sign this thread as solved..