solving N equations N unknowns in vba

Milade8080

New member
Joined
Mar 13, 2014
Messages
19
Reaction score
0
Points
0
hi
solving N equations N unknowns in vba With the following conditions:
Example

a[SUB]11[/SUB]X[SUB]1 [/SUB]+a[SUB]12[/SUB]X[SUB]2[/SUB]+……+a[SUB]19[/SUB]X[SUB]9[/SUB] = b[SUB]1[/SUB]
a[SUB]21[/SUB]X[SUB]1 [/SUB]+a[SUB]22[/SUB]X[SUB]2[/SUB]+……+a[SUB]29[/SUB]X[SUB]9[/SUB] = b[SUB]2[/SUB]
. . . . . . . . . . . . .
a[SUB]91[/SUB]X[SUB]1 [/SUB]+a[SUB]92[/SUB]X[SUB]2[/SUB]+……+a[SUB]99[/SUB]X[SUB]9[/SUB] = b[SUB]9[/SUB]
in Sheet 1
a11 in Cell A1 and a12 in Cell B1 ...
a21 in Cell A2 and a22 in Cell B2 ...
.....
.....

in Sheet 2

b1 in Cell A1
b2 in Cell A2
....
....

in Sheet 3 (An important part of my question)
solving N equations N unknowns Without using any formula, just press button key
---------------------------------------------
Tanks
 
Last edited:
Top