Hi all,
My problem is that I have a mutlidimensional array created using this piece of coding:
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 xCubNumbers = Worksheets("Attendance Sheet 2012").Cells(Rows.Count, 1).End(xlUp).Row SrchRng = "A3:BT" & CubNumbers AttendanceArray = Worksheets("Attendance Sheet 2012").Range(SrchRng).Value
Bookmarks