PDA

View Full Version : Solved: How to get the size of an array?



mleary2001
02-06-2006, 02:58 PM
How does one get the size of a dynamic array in VBA on Office X?

Thanks in advance,
Mike:banghead:

Norie
02-06-2006, 03:02 PM
Mike

Wouldn't you use UBound?

mleary2001
02-06-2006, 04:46 PM
Thanks Norie

Mike

dub
08-04-2011, 09:47 AM
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!

mikerickson
08-04-2011, 11:49 PM
What is your code?