Consulting

Results 1 to 5 of 5

Thread: Solved: How to get the size of an array?

  1. #1
    VBAX Regular mleary2001's Avatar
    Joined
    Feb 2006
    Location
    Missoula
    Posts
    12
    Location

    Question Solved: How to get the size of an array?

    How does one get the size of a dynamic array in VBA on Office X?

    Thanks in advance,
    Mike

  2. #2
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Mike

    Wouldn't you use UBound?

  3. #3
    VBAX Regular mleary2001's Avatar
    Joined
    Feb 2006
    Location
    Missoula
    Posts
    12
    Location

    Solved: How to get the size of an array

    Thanks Norie

    Mike

  4. #4
    VBAX Regular dub's Avatar
    Joined
    Nov 2010
    Location
    Boulder, CO
    Posts
    18
    Location
    i am trying to do the same thing but Ubound is not working b/c my array is pulled from a filtered sheet in excel and the row numbers are not in order, the last row number is 33800 but the array is from filtered data and only has about 1000 rows. Ubound is returning 33800. Any ideas?

    Thanks!
    Dub

  5. #5
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,778
    What is your code?

Posting Permissions

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