Ubound multidimensional array

[Shiro26]

Hi there,

I have been looking for an answer to this question and didn t find the answer I was looking for.
Let s consider the 3D array with the following dimension:
Array(A,B,C)

I call a1 the first slice of my cube
I call a2 the second slice of my cube,
and so on

I call b1 the number of rows of my first slice
I call b2 the number of rows on my second slice
and so on

I call c1 the number of columns of my first slice
I call c2 the number of column on my seccond slice
and so on

The bi with i = 1 to B is varying from slice to slice.

Question:
I am interested in the second slice: Array(2, b2, c2)
Could somebody explain me what should be the VBA code to return me the number of rows of my second slice -in other word the b2.
Could somebody explain me what should be VBA code to return me the number of columns of my second slice -in other word the c2.

Thank you very much in advance for your explanation...

Kind Regards,

Shiro

 

[RoryA]

All your slices are the same shape, so it's simply Ubound(array,2) and ubound(array,3) to get the upper boundaries of b and c.