Results 1 to 3 of 3

Thread: How do I determine the size of an array

  1. #1

    Thread Starter
    New Member
    Join Date
    May 2000
    Location
    Chicago
    Posts
    2

    Question

    How do I determine the size of a multi-dimensional array?
    I have an array called table(row,col), which varies every time the program is run. How do I determine how many columns and rows there are?

    Thank you.
    Jon

  2. #2
    Fanatic Member r0ach's Avatar
    Join Date
    Dec 1999
    Location
    South Africa
    Posts
    722
    Use the ubound() function

    Code:
    ' Usage:
        Dim rowcount as long
        Dim colcount as long
        rowcount = ubound(table, 1)
        colcount = ubound(table, 2)

    r0ach™
    Don't forget to rate the post

  3. #3

    Thread Starter
    New Member
    Join Date
    May 2000
    Location
    Chicago
    Posts
    2

    Cool Array Size

    Thank you

Posting Permissions

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



Click Here to Expand Forum to Full Width