Application.Index(array1,n,0) will return the nth row of array1

Alan Beban

Chris wrote:
Is there a way to return a one-dimensional array from a
multi-dimensional array?
For example, I have the following two-dimensional array;

A B C D E F G
H J K L M N O
P Q R S T U V

Dim array1(2, 7) As String

But I want to get, say, the first row but when I enter array1(0) VBA
produces an error.

In Java, the above commnad, array1(0) will return an array containing
the items in the first row,
but in VBA, I couldn't figure out how to do it.

Do I have to create a one-dimensional array with variant type, then
enter one-dimensional arrays containing each row?

Thanks.