ExcelBanter - matrix size

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - matrix size (https://www.excelbanter.com/excel-programming/373392-matrix-size.html)

Arne Hegefors

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)

Stefi

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)

All times are GMT +1. The time now is 11:29 PM.