Matrix of VBA

[francesc]

hi there
i am new to this forum and have a urgent question about the matrix application in VBA and want to ask you for help. the problem is about the deflection of a beam
the formula is
Q/EI = y(i-2)-4y(i-1)+6y(i)-4y(i+1)+y(i+2)
I want the output matrix is like this
1 -4 6 -4 1 0 0 0
0 1 -4 6 -4 1 0 0
0 0 1 -4 6 -4 1 0
.....
.....

is it possible?

 

[patel45]

it's not clear for me

 

[francesc]

it's not clear for me

in the VBA program, i know how to allow the user to enter the value in each cell of a matrix
but now i want to transform a "equation into a matrix", say 3x+5y-6z
and the matrix is a 4 by 6 matrix
i expect the output is
3 5 6 0 0 0
0 3 5 6 0 0
0 0 3 5 6 0
0 0 0 3 5 6
is it possible?

thank you very much

 

[patel45]

It would be easier to assign the values 3 5 -6 to 3 cells A1, A2, A3 then get the matrix

 

[patel45]

put known terms in the first row, then try this code,

Sub a()
kterms = 3
nrow = 4
ncol = 6
drow = 3 ' destination row
Set Rng = Range(Cells(1, 1), Cells(1, kterms))
Range(Cells(drow, 1), Cells(drow + nrow - 1, ncol)) = 0
For j = 0 To nrow - 1
  Rng.Copy Cells(j + drow, j + 1)
Next
End Sub