VBA Excel Macro for 'n x n' Matrix formation based on user inputs?? - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

VBA Excel Macro for 'n x n' Matrix formation based on user inputs??

reachspk123reachspk123 Posts: 1Member
Dear All,

Can somebody help me out in generating a macro for forming a "n x n" matrix based on user inputs. - Excel sheet enclosed. Send me ur replies to [email protected] :)
Inputs:

i j Value

1 2 1
1 3 1
1 4 -1
1 8 -1
2 1 1
2 4 1
2 5 -1
2 6 -1
3 5 1
3 6 1
3 7 -1
4 1 130.1459226
4 4 -160.8272092
4 2 -144.5355421
5 2 144.5355421
5 3 -183.6928125
6 2 144.5355421
6 4 160.8272092
6 5 137.3575476
6 7 152.8315505
7 2 144.5355421
7 4 160.8272092
7 6 137.3575476
7 7 152.8315505
8 3 183.6928125
8 8 172.7183057

In remaining locations, values are zero.

i j Value
1 1 0
1 5 0 etc.,

Here, we have 8x8 matrix. But, this should be generalized for forming "n x n" matrix


Please get me an Excel Macro for this.
Thanks in advance,
Prakash

Sign In or Register to comment.