Returns a two dimensional matrix with the cube data matrix, excluding hidden elements.
Return type
Two dimensional array of variant
Parameters
Example
Dim matrix()
With Cube1
matrix = .getMatrix()
Call printMatrix(matrix)
end with
Sub printMatrix(mat() As Variant)
Dim i As Long
Dim j As Long
Dim iMax As Long
Dim jMax As Long
Dim str As String
iMax = UBound(mat, 1)
jMax = UBound(mat, 2)
Debug.Print iMax, jMax
str = ""
For i = 0 To iMax
For j = 0 To jMax
str = str & mat(i, j) & vbTab
Next j
str = str & Chr(10)
Next i
Debug.Print str
End Sub
Explanation
Retrieves the data matrix values and prints them in the str variable.
See also
Use GetMatrixNH to retrieve the matrix including hidden elements.
Use GetMatrixTrans to retrieve this matrix, but transposed.