VBA Programming Question

hunting · October 21st, 2004, 6:57 pm

Hey..Can anyone help me with something? I want to make a 21 x 1 array, where each entry of the array is itself a vector of dates. However, each of the vectors is of a different dimension. I could always make a matrix of n x 21 where n is the maximum dimensionality of the individual vectors, and backfill with zeroes for the rest; but I was hoping for a cleaner solution. Any advice?Thanks and best rgds

magriggs · October 21st, 2004, 7:47 pm

Hmmm, easy to do in C++ or a similar language, but I don't know about VBA. Can you assign an array member to be a pointer to another array? I suspect not. The n x 21 might be your only choice, sadly

daveangel · October 21st, 2004, 8:58 pm

does it have to be an array ? you could use a collection

Russell · October 22nd, 2004, 5:54 am

in VBA:dim arr1(1 to 21) as variantarr(i) = datevectorthen arr(i)(j) gives you the jth element of the ith vector

FastExcel · October 22nd, 2004, 6:02 am

You can do it using variants:Sub RaggedVar()Dim vArr(4) As VariantDim vArr2(6) As VariantvArr2(2) = "Fred"vArr(1) = Array(1, 2, 3, 4)vArr(2) = vArr2MsgBox vArr(1)(1)MsgBox vArr(2)(2)End SubRun the above in debug mode and look at Varr in the locals window to see whats happening.

afoster · October 22nd, 2004, 7:57 am

I assume when you say Vector, you are talking about an object container type, similar to the ones found in the C++ STL. If this is the case, you simply Dim your array as a Vector type. If you haven't got a vector class to hand - attached is a code sample.

hunting · October 26th, 2004, 12:48 pm

many thanks to all!