Home Create matrix from predefined cells
Reply: 1

Create matrix from predefined cells

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 Reply to 2018-02-14 17:05:32Z

to fill an array with range values you simply go like follows:

Dim eigenvalueMatrix As Variant

eigenvalueMatrix = Range("A1:C3").Value
You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.699954 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO