How does one get the size of a dynamic array in VBA on Office X?
Thanks in advance,
Mike
How does one get the size of a dynamic array in VBA on Office X?
Thanks in advance,
Mike
Mike
Wouldn't you use UBound?
Thanks Norie
Mike
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
What is your code?