Results 1 to 6 of 6

Thread: No of columns in an array [Resolved]

  1. Mar 16th, 2005, 05:43 AM #1
    flair
    flair is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2004
    Posts
    176

    Resolved No of columns in an array [Resolved]

    Hi everybody,
    I have a very simple problem.
    I have a variant that is a two dimensional array.
    UBound(arrayName) gives the no of rows. How do I get the no of columns?
    Thanks,
    Flair
    Last edited by flair; Mar 16th, 2005 at 06:04 AM.
    Reply With Quote Reply With Quote
  2. Mar 16th, 2005, 05:56 AM #2
    trisuglow
    trisuglow is offline
    Frenzied Member trisuglow's Avatar
    Join Date
    Jan 2002
    Location
    Horsham, Sussex, UK
    Posts
    1,536

    Re: No of columns in an array

    I don't understand. If it's a two-dimensional array then it will always have two columns
    This world is not my home. I'm just passing through.
    Reply With Quote Reply With Quote
  3. Mar 16th, 2005, 05:57 AM #3
    RobCrombie
    RobCrombie is offline
    Fanatic Member
    Join Date
    Mar 2002
    Location
    AUSTRALIA
    Posts
    603

    Re: No of columns in an array

    Ubound(MyArray, 2)
    Rob C
    Reply With Quote Reply With Quote
  4. Mar 16th, 2005, 05:57 AM #4
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: No of columns in an array

    the second dimension
    Reply With Quote Reply With Quote
  6. Mar 16th, 2005, 05:59 AM #5
    dglienna
    dglienna is offline
    Banned dglienna's Avatar
    Join Date
    Jun 2004
    Location
    Center of it all
    Posts
    17,901

    Re: No of columns in an array

    That's it. I knew it but couldn't think of it. I've written it in my book. I'm surprised that M$ didn't list it.
    Reply With Quote Reply With Quote
  7. Mar 16th, 2005, 06:04 AM #6
    flair
    flair is offline

    Thread Starter
    Addicted Member
    Join Date
    Aug 2004
    Posts
    176

    Re: No of columns in an array

    Thanks Rob.
    Cheers!
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules


Click Here to Expand Forum to Full Width