Dreaded MultiDimensional Array 1

[sn0rg]

Having real problems creating and populating one.

I want to read in the content of a spreadsheet into an array. I count each row incrementing a variable (intRow) until I reach the end of the sheet. I know there will be 4 columns.

Problem is, that I cannot then use the intRow variable to declare the array (ie Dim MyArray(intRow,3). I get a Expected Literal Constant error.

How can I use intRow (or some derivative of it) to declare the array?

 

[tsuji]

If the variable dimension is not the last, you can do it once and once only.
[tt]
dim a 'or dim a(), both the same
n=10
redim a(n,3)
wscript.echo ubound(a,1)
[/tt]
If you want to change more times, you need to make it to the last index.

 

[sn0rg]

Thanks Tsuji, works a treat.