Return the number of rows in an array

[atf32]

Looking for a function that returns the number of rows that exist and an array. I used "Ubound", but if there is only one row in the array, I end up with the number of columns in the array.

 

[kpark91]

I have no idea what you're asking.
Are you talking about 2 dimensional array?

Is so, what is the row and column of the array?
array(r)(c) ?

 

[Norie]

How have you created/populated this array?

If it has more than one dimension you can use the 2nd argument of UBound to specify which dimension you want the upper bound for.

If it is rows and columns you can use something like this:

arrvals = Range("C1:G3").Value
cols = UBound(arrvals, 2)
rws = UBound(arrvals, 1)