Multidimensioanal Array sizing

Hi all,

My problem is that I have a mutlidimensional array created using this piece of coding:

Please Login or Register  to view this content.

What I need to be able to do is work out how many entires I have got for each row of the array eg: AttendanceArray(1,1)...........AttendanceArray(x,1) what is the maximum value of x

If you want to get the max value in column you can probably try

Please Login or Register  to view this content.

Hi davidWA
The UBound function is used with the LBound function to determine the size of an array

Please Login or Register  to view this content.