RESOLVED[Vector in vba]

[Fonty]

Lets say I declare the following variables which are between 0 and 1.

Dim a As byte
Dim b as byte
Dim c As byte
Dim d As byte
'... etc

In fact there are 37 variables.

Then I have a list of 37 constants in some worksheet, and I put them into a vector called m.

Dim m() As Integer
ReDim m(37)
For i= 1 to 37
m(i)= Cells(1,i).Value
Next i

My problem is to compute the following product:
op=a*m1+b*m2+c*m3+...
How can I use each of the elements of the vector m, in order to multiply them to an indiividual element (e.g. a or b or c, etc)?

[si_the_geek]

Moved to Office Development forum (as this is a code issue, rather than a mathematical problem)

As you have it, you can't.

Your a/b/c/etc.. need to be an array, just like m is. You can then use a loop to add/multiply the values together, eg:

Dim mul() as Byte  '(same as a/b/c/etc)
Dim myTotal as Long
  ReDim mul(37) as Byte
  'set values for mul here
 
  myTotal = 0
  For i = 1 to 37
    myTotal = myTotal + mul(i) * m(i)
  Next i
 
  MsgBox myTotal