MethodGetMatrixNH
DescriptionReturns a two dimensional matrix with the cube data matrix, including hidden elements.
Return typeTwo dimensional array of variant
Parameters
ExampleDim matrix()
With Cube1
 matrix = .getMatrixNH()
 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
ExplanationRetrieves the data matrix values and prints them in the str variable.
See also

Use GetMatrix to retrieve the matrix excluding hidden elements.

Use GetMatrixTrans to receive the matrix excluding hidden elements, but transposed.

Notes