Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Assigning big 2D arrays
Hi,
Assigning small 2D arrays is easy. This is a 3x6 array: Array_A = [{1, 3, 6, 10, 0, 0; 1, 1.2, 4.5, 6.8, 9.2, 10; 0, 0, 0, 0, 2, 3}] Every line is separated by ";". But when I type in bigger arrays and cut the line with a " _", as I do for all other lines in the code that becomes to long, I get an error message, "Missing end bracket" Can anyone tell me why this doesn't work? How can I assign a 4x49 (or even 4x97) element array? I can assign 1D arrays with 49 elements, but is it possible to build a 2D array out of these 1D arrays? Is that a way to get round the probelm? I have also problem with dimensioning these arrays. When I write Dim Array_A(1 To 4, 1 To 49) As Variant I get an error "Can't assign to an array" when I Assign to the array |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Assigning a Value | Excel Discussion (Misc queries) | |||
Working with ranges in arrays... or an introduction to arrays | Excel Programming | |||
Arrays - declaration, adding values to arrays and calculation | Excel Programming | |||
Assigning a value to a name | Excel Worksheet Functions | |||
Assigning range names to arrays | Excel Programming |