Solved: How to get the size of an array?

[mleary2001]

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

Thanks in advance,
Mike

[Norie]

Mike

Wouldn't you use UBound?

[mleary2001]

Thanks Norie

Mike

[dub]

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]

What is your code?