Results 1 to 5 of 5

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

  1. 02-06-2006, 02:58 PM #1
    mleary2001
    mleary2001 is offline
    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
    Reply With Quote Reply With Quote
  2. 02-06-2006, 03:02 PM #2
    Norie
    Norie is offline
    VBAX Master Norie's Avatar
    Joined
    Jan 2005
    Location
    Stirling, Scotland
    Posts
    1,831
    Location
    Mike

    Wouldn't you use UBound?
    Reply With Quote Reply With Quote
  3. 02-06-2006, 04:46 PM #3
    mleary2001
    mleary2001 is offline
    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
    Reply With Quote Reply With Quote
  4. 08-04-2011, 09:47 AM #4
    dub
    dub is offline
    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
    Reply With Quote Reply With Quote
  5. 08-04-2011, 11:49 PM #5
    mikerickson
    mikerickson is offline
    Mac Moderator VBAX Guru mikerickson's Avatar
    Joined
    May 2007
    Location
    Davis CA
    Posts
    2,773
    What is your code?
    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