Home Create matrix from predefined cells

# Create matrix from predefined cells

user507
1#
user507 Published in June 21, 2018, 6:29 am
 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!
 You need to login account before you can post.
Processed in 0.270737 second(s) , Gzip On .