Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Returning an array from a multi-dimensional array
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. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Multi Dimensional Array | Excel Programming | |||
Multi Dimensional Array | Excel Programming | |||
Multi-dimensional Array Referencing | Excel Programming | |||
Multi-Dimensional Array Let & Get | Excel Programming | |||
Enumerating a multi-dimensional array | Excel Programming |