I have an array of arrays... not a mult-dimensional array. I want to be able to dynamically redimension each array, but VB doesn't like how I'm doing it. I think it's not possible, but if anyone knows how, it would save me from rewriting a lot of code.

I want to be able to do this:

Like this:

arr(9)(12)

Not like this:

arr(9, 12)

VB Code:
  1. Private arr() As Variant
  2.  
  3. Sub AddArrayDimension(ArrayIndex As Long)
  4.  
  5. Redim Preserve Array(ArrayIndex)(Ubound(Array(ArrayIndex)) + 1)
  6.  
  7. End Sub

Anyone have any good ideas about how to do this specifically?