Hello,
I am working with multidimensional arrays in excel
Is it any way I can apply the Redim function to them
For example I have an array ReplacementSchedule(,6)
I know the number of columns but I learn dynamically the number of rows
Ideally I would have liked to be able to say ReDim(ReplacementSchedule(NumRows,6))
However that does not work
Any ideas of how to install dynamic multidimensional arrays in excel?
Regards
Dora
You can only re-dim the final dimension of a dynamic array. So in your case, the number of columns rather than rows.
There are numerous approaches to a solution to this but they would be dependant on your scenario. Likely solutions would be multiple 1d arrays, 1 single array for rows and multiple 1d arrays for columns so you have an array of arrays, you could utilise a collection object in the same way, or you could transpose your data so you have rows as columns and columns as rows.
Edit: After reading Norie's comments, I think I got the wrong end of the stick with this one. To clarify, you can only redim the last dimension of an array once it's been dimensioned
Last edited by Kyle123; 11-05-2012 at 08:36 AM.
Dora
Does this work?
Please Login or Register to view this content.
If posting code please use code tags, see here.
Hello Thanks
But How do I define a dynamic multidimenasional array
Dim ReplacementSchedule(,1 To 6) As Variant that does no work
Please Login or Register to view this content.
Dora
If you mean you don't know the first dimension then it's not possible to omit it.
Why not redim the array when you know the no of rows?
Thanks for your suggetsion it works now
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks