Sub practice()
Dim sht As Worksheet
Set sht = Worksheets("R401a")
Dim one, two As Range ' two will be treated the same as one, just haven't coded it yet.
Set one = sht.Range("one")
Set two = sht.Range("two")
Dim arr()
arr = sht.Range("one") ' one is a excel table I named
Dim i As Integer
For i = LBound(one) To UBound(one)
var1 = arr(i,1)
var2 = arr(i,2)
var3 = arr(i,3)
var4 = arr(i,4)
x= var1*var2*var3*var4 ' the actual equation is more complicated, using specific variables.
Next i
End Sub
<tbody>
</tbody>
I was wondering if there was a way to make this more automated, as in, automatically making the var1, var2.... from the header row, then setting them equal to the column values. So that the same macro would work on, say
<tbody>
</tbody>
Dim sht As Worksheet
Set sht = Worksheets("R401a")
Dim one, two As Range ' two will be treated the same as one, just haven't coded it yet.
Set one = sht.Range("one")
Set two = sht.Range("two")
Dim arr()
arr = sht.Range("one") ' one is a excel table I named
Dim i As Integer
For i = LBound(one) To UBound(one)
var1 = arr(i,1)
var2 = arr(i,2)
var3 = arr(i,3)
var4 = arr(i,4)
x= var1*var2*var3*var4 ' the actual equation is more complicated, using specific variables.
Next i
End Sub
| var1 | var2 | var3 | var4 |
| 1 | 3 | 5 | 6 |
| 5 | 2 | 1 | 5 |
| 5 | 8 | 2 | 4 |
<tbody>
</tbody>
I was wondering if there was a way to make this more automated, as in, automatically making the var1, var2.... from the header row, then setting them equal to the column values. So that the same macro would work on, say
| Change_In_temperature | mass | Enthalpy |
| 4 | 8 | 4180 |
| 8 | 5 | 4172 |
| 12 | 6 | 4195 |
<tbody>
</tbody>
