Home Create matrix from predefined cells

# Create matrix from predefined cells

Brossi
1#
Brossi Published in 2018-02-14 16:42:08Z
 Good afternoon, I'm quite new to VBA and Excel and i'm having the following problem. I have a function that requires a symmetric matrix as input to calculate the eigenvalue [=MEigenvalueMax (A1: C3)]. However, I have the data for the matrix in different cells. My question is therefore whether there is a function with which I can define predefined cells as a matrix, e. g. =MEigenvalMax ({A1, A2, A3; B1, B2, B3; C1, C2, C3}). Thank you for the answers!
DisplayName
2#
 to fill an array with range values you simply go like follows: Dim eigenvalueMatrix As Variant eigenvalueMatrix = Range("A1:C3").Value