I have a large variant array (1 to 50000, 1 to 50). I'd like to set a
variable equal to the number of 'rows' of data that are actually in the
array, so I can use that in other parts of my code. lbound/ubound seems to
return the whole array size regardless of how much of the array contains
data.

When checking for the last used row in a worksheet I use:

Function Find_Last(sht As Worksheet)
Find_Last = sht.Cells.Find(What:="*", After:=sht.Range("A1"),
LookAt:=xlPart, _
LookIn:=xlFormulas, SearchOrder:=xlByRows, _
SearchDirection:=xlPrevious, MatchCase:=False).Row
End Function

Is there an equivalent for arrays (that avoids looping the entire array and
checking for blank values)?

Thanks!
Keith