I simply have the issue that I need to create an array with a number of arrays. the problem is that the number of the arrays are only known at runtime. so, how can initialize (create) the array with the correct size?
Thanks a lot!
-
1You'll have to run some code that figures it out first.Ron Rosenfeld– Ron Rosenfeld2014-06-03 22:04:30 +00:00Commented Jun 3, 2014 at 22:04
-
1I guess the key here is ReDim as what @brettdj posted which Re-dimensions array at runtime.L42– L422014-06-04 05:35:08 +00:00Commented Jun 4, 2014 at 5:35
Add a comment
|
1 Answer
As per Ron's comment, use variables to set your array when it is known.
Dim lngRow As Long
Dim lngCol As Long
Dim X()
lngRow = 100
lngCol = 15
ReDim X(1 To lngCol, 1 To lngRow)
2 Comments
JFS
Thanks for your help. I didn't want to use matrix arrays before but it might help me. I need to figure that out. Anyway, I found another question with well described solutions. Give me some time to understand the difference between those and your solutions. Thank you so far.
JFS
I could find a way to use the matrix array effectively. Thanks for the help.