How to reference equations with for loop index notation in macros?

[pericopericone]

Hi,

I am having a problem with a code in excel; I have searched the solution for 2 days on the internet and it seems there is no solution to something so simple. I want the code to write the function "= .15 * prices!Bi" where the index i is any integer from 1 to 1175 corresponding with the if statement. B is the column and i is the variable number


Here is the code I have in excel:

Sub test()
Dim i As Integer
Dim j As Integer

For i = 1 To 1175
For j = 1 To 439

If (Worksheets("prices").Cells(i, 1).Value = Worksheets("beachwood").Cells(j, 1).Value) Then
Worksheets("beachwood").Cells(j, 2).Formula = "= .15 * prices!Bi"
End If
Next j
Next i

End Sub

[mike7952]

Try this

Please Login or Register  to view this content.

[pericopericone]

Thank you so much that solves my problem, but before you mark this as solved, please tell me how to solve this:

"= .15 * prices!Bi + prices!Bi"

[mike7952]

This should do it

Please Login or Register  to view this content.

Also should use code tags when posting codes. You can click on the # sign above and paste your code between the code tags [Code]Paste Here[Code]

Also if your satisfied with the solution then you can mark the thread as solved.