szesz
04-01-2016, 02:52 AM
Hi All,
Can someone help me with this?
The task is to write a function in VBA that determines about a given range whether it can be a correlation matrix (i.e. whether the range is a square form, whether it has all values as numbers, whether the diagonal has only values of 1, whether the matrix is symmetrical, and whether the values of the matrix are in the [-1; 1] interval). I have thought of doing this with several IF commands, but I am unsure whether that's the best solution... this is probably very easy to do but I have only started learning VBA a few weeks ago so I am not really confident yet. Thanks for any help! in advance!!!
Can someone help me with this?
The task is to write a function in VBA that determines about a given range whether it can be a correlation matrix (i.e. whether the range is a square form, whether it has all values as numbers, whether the diagonal has only values of 1, whether the matrix is symmetrical, and whether the values of the matrix are in the [-1; 1] interval). I have thought of doing this with several IF commands, but I am unsure whether that's the best solution... this is probably very easy to do but I have only started learning VBA a few weeks ago so I am not really confident yet. Thanks for any help! in advance!!!