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

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 reachspk@gmail.com :)
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.

Howdy, Stranger!

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

Categories