Declaring multiple multi-dimensional arrays (jagged arrays) - compile error?

Hi -

I'm trying to declare multiple dynamic arrays, with each dynamic array having the same dimensions.

(I'm taking data from two separate sheets that have the same dimensions but different values, and want to subtract one from the other).

So Array1 has two dimensions of unspecified size
and Array2 has two dimensions of the same unspecified size.

I would think the declaration would be Dim Array(2)() as Variant (or whatever)

Another option would be to declare a 3 dimensional array, Dim Array(2,,)

I found these examples in the MSDN VBA guide. But I get a compile error when declaring these. From reading through a bunch of threads, it seems that this has something to do with the difference between VBA.net and VBA for Excel (I'm using the latter). Why there are two different types of VBA from the same company that don't recognize the same code, I have no idea. I'll chalk that up to yet another way Microsoft makes people's lives miserable.

So any help would be appreciated. How do I declare an sequence of 2-dimensional arrays - Array1,Array2,Array3 -

Where Array(1)(1,1) = the first cell in the array1
and Array(2)(1,2) = the first cell in array2

But important note, I don't know in advance the dimensions of the arrays, I only know I need 2 (or more) of them, all with the same dimensions but different values.

Thanks for any help.

Dave

To create 2 separate arrays you give them 2 different variable names ie. array1 and array2. To determine the size of the array you use the parenthesis.

U can use ubound to find the end of the array, or if your data is continuous you can just check for empty values to stop. If you are doing dynamic then you are keeping track of each value being placed into the array so you would know when it ends.

Here is an example

Please Login or Register  to view this content.

OK, thanks everyone. This is helpful.

As far as the question to how I'm going to subtract them:

For x = 1 to [upper bound of x dimension]
For y = 1 to [upper bound of y dimension]
SubtractedArray(x,y) = Array1(x,y) - Array2(x,y)
Next y
Next x

I'd still think it would be simpler if I could declare it like Dim Array(2)()() as [whatever] to signify that I know there are 2 arrays but don't know the x and y dimensions of them (and will define later in code).

But AB33's idea will do the trick.

Thanks for the quick reply.

Dave

Dave

well that depends where you want to hold the subtracted value, right now you created a 3rd array to hold the new value. you can easily put subtracted value back into one of the 2 arrays you started with if you want. If you make the 3rd array, you'll just have to take ubound of both arrays and use the largest dimension of both.