Results 1 to 3 of 3

Multidimensioanal Array sizing

Threaded View

  1. #1
    Registered User
    Join Date
    01-04-2012
    Location
    Perth, WA
    MS-Off Ver
    Excel 2010
    Posts
    6

    Multidimensioanal Array sizing

    Hi all,

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

    CubNumbers = Worksheets("Attendance Sheet 2012").Cells(Rows.Count, 1).End(xlUp).Row
    
    SrchRng = "A3:BT" & CubNumbers
    
    AttendanceArray = Worksheets("Attendance Sheet 2012").Range(SrchRng).Value
    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
    Last edited by davidWA; 01-08-2012 at 01:07 AM.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1