Thread: matrix size
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Stefi Stefi is offline
external usenet poster
 
Posts: 2,646
Default matrix size

x = UBound(strRatingMatrix, 1)
y = UBound(strRatingMatrix, 2)

Regards,
Stefi


€˛Arne Hegefors€¯ ezt Ć*rta:

I have a 2 dimenisonal matrix. I want to find the size of the different
dimensions.
I know how find one dimension by using the Ubound. This gives me x=3.
However I would like to know the other dimension also, ie 5. Can yuo please
help me? Thank you very much!

Option Base 1
Dim strRatingMatrix() As String
ReDim strRatingMatrix(3, 5)
x = UBound(strRatingMatrix)