Thread: matrix size
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Arne Hegefors Arne Hegefors is offline
external usenet poster
 
Posts: 244
Default matrix size

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)