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)?