Pascalvrolijk
Board Regular
- Joined
- May 28, 2004
- Messages
- 68
Hi dearest helping hand,
Been trying but cant find out the solution..
I have a dynamic matrix that gets an extra row within a forloop (time and time again until there are between 3,000,000 and 4,000,000 rows). I want to keep the previous lines as well but redim preserve doesnt work for reason i dont understand. Could someone please help me? The matrix is defined as Variant.
part of the code within a loop is:
k = k + 1
ReDim VBA_matrix(1 To k, 1 To 5)
in second line it gives error 9 during running, subscribt falls out of reach.
Thanks for any and all help!
Greetings,
Pascal.
Been trying but cant find out the solution..
I have a dynamic matrix that gets an extra row within a forloop (time and time again until there are between 3,000,000 and 4,000,000 rows). I want to keep the previous lines as well but redim preserve doesnt work for reason i dont understand. Could someone please help me? The matrix is defined as Variant.
part of the code within a loop is:
k = k + 1
ReDim VBA_matrix(1 To k, 1 To 5)
in second line it gives error 9 during running, subscribt falls out of reach.
Thanks for any and all help!
Greetings,
Pascal.